Measure total returns 0 when SELECTEDVALUE is used within the measure

Quiny_Harl — Wed, 09 Mar 2022 15:41:47 GMT

Hi PBI folks,

I have a measure that I use in a matrix visual and the measure returns a result only for certain rows of the matrix depending on their value. For the rest it returns 0.

Type	Measure
One	50
Two	0
Three	10
Four	0
Total	0

Measure=
IF(
SELECTEDVALUE(My_Table[Type]) IN {"One","Three"},

CALCULATE(
SUMX(My_Table,[Price]*[Qty]),

)
So I want my measure to calculate Price*Qty only when Type is "one" or "three" and return 0 for the rest. I also want the Total to be the sum of "one" and "three". However, in my case the Total is 0.

How can I modify my measure to make it return a total that is a sum of one and three?

Re: Measure total returns 0 when SELECTEDVALUE is used within the measure

amitchandak — Wed, 09 Mar 2022 15:57:36 GMT

Quiny_Harl , I think this should also work

CALCULATE(SUMX(My_Table,[Price]*[Qty]),filter(My_Table, My_Table[Type]) IN {"One","Three"}
)+0

topic Measure total returns 0 when SELECTEDVALUE is used within the measure in Desktop

Measure total returns 0 when SELECTEDVALUE is used within the measure

Re: Measure total returns 0 when SELECTEDVALUE is used within the measure