Forum Discussion
o59393
Post Prodigy
Post ProdigyMetric 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 ...
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 )
MFelix
Super User
Super UserHi 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
)