Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!