Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a very simple example table - purchases from vendors with item number, vendor name, amount and a paid flag (yes/no).
I have a measure that calculates the total amount:
Solved! Go to Solution.
try this measure for Total Paid:
Total Paid = CALCULATE ( [Total Cost], FILTER ( Purchases, Purchases[Paid] = "Yes" ) )
try this measure for Total Paid:
Total Paid = CALCULATE ( [Total Cost], FILTER ( Purchases, Purchases[Paid] = "Yes" ) )
@Anonymous Thanks a lot, this worked. Why does this work and not the other way around?
The original Total Paid measure is overriding the filter context coming from your slicer, essentially it is equivalent of the following formula:
Total Paid = CALCULATE ( [Total Cost], FILTER ( ALL ( Purchase[Paid] ), Purchase[Paid] = "Yes" ) )
ALL function ignore any filters coming from your data model. See reference here.
@Anonymous Makes sense, thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |