Metric shows duplicated value

[o59393]

Hi all

I created a measure that is multiplied by a parameter. In this case the measure should only affected one country, however it is impacting all the countries in my table.

The mesaure is simple:

Volume what if = CALCULATE(
    SUM(Sheet1[Value]) * 
    Parameter[Parameter Value],
    'Origin-Destination'[Destination]=
    "Brazil"
)

The measure should only impact Brazil but see below how the result for Brazil is duplicating in the rest of the coutries:

The solution desired would be 53,765 for Brazil only

How can I fix the measure?

Regards

[MFelix · Accepted solution]

Hi @o59393 ,

When you write the calculate function you are impacting all values since the parameter does not have any connection to the countries so impact all the countries, try the folllowing formula:

Volume what if = CALCULATE(
    SUM(Sheet1[Value]) * 
    IF(SELECTEDVALUE('Origin-Destination'[Destination])=
    "Brazil",
[Parameter Value],1
)

[o59393]

@MFelix  Perfect!! Thanks a lot Miguel 🙂