Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
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.
If you click the number 2047 from that object with the measure, does the other object also filter?
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |