Calculate in measure at column won't filter other objects

[JayV]

Hi!
I placed this measure in "values" on a Matrix:

measure = CALCULATE(sum(Fact[Totalsum]),Fact[type] = "D")

But when i select anything within this matrix it will filter all objects from the model excluding Fact[type] = "D"  and showing the absolute total

(Measure total is selected)

I also tried using SumX but didn't work:

measure = SUMX(FILTER(Fact,Fact[type] = "D"),Fact[Totalsum])

Why could this be?

[v-jincheng-msft]

Hi @JayV ,

Hi, thanks for the information you have given. I tested the sample based on this information and Filter did not have the problem you mentioned. 

Please feel free to correct me and provide more information if I have misunderstood you!

Hope it helps!

Best regards,
Community Support Team_ Joseph Ji

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[JayV]

If you click the number 2047 from that object with the measure, does the other object also filter?