Forum Discussion

o59393's avatar
o59393
Post Prodigy
5 years ago
Solved

Metric shows duplicated value

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

Need Help
Show and Tell
  • MFelix's avatar
    MFelix
    5 years ago

    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
)

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    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
)