Measure total returns 0 when SELECTEDVALUE is used within the measure

[Quiny_Harl]

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]),

                            ),

      0

    )
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?

 

[amitchandak · Accepted solution]

@Quiny_Harl , I think this should also work

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