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 measures
1. sums qty where cat <> 'A'
there are many other categories
when the slicer is selected with only cat 'A' you would expect measure 1 to show 0? but instead it shows the total of every other cat?
Solved! Go to Solution.
I adjusted to
Quantity Non Billable = CALCULATE(SUM('fact_Time Sheet Detail'[Quantity]), KeepFilters(dim_Resource[Global Dimension 2 Code] <> "ADM"), 'fact_Time Sheet Line'[Chargeable] = 0)
It's working now... Thanks!
Hey @donjek ,
that depends on how exactly you wrote your measure.
Please post the actual measure you are using and we can answer your question. Don't post pseudocode, that will just lead to pseudo answers...
Best regards
Denis
Hi, Thanks for the reply!
here is the measure:
I adjusted to
Quantity Non Billable = CALCULATE(SUM('fact_Time Sheet Detail'[Quantity]), KeepFilters(dim_Resource[Global Dimension 2 Code] <> "ADM"), 'fact_Time Sheet Line'[Chargeable] = 0)
It's working now... 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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |