conflicting filters Slicer with Measure

[donjek]

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?

[selimovd]

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

[donjek]

Hi, Thanks for the reply!

here is the measure:

Quantity Non Billable = CALCULATE(SUM('fact_Time Sheet Detail'[Quantity]), dim_Resource[Global Dimension 2 Code] <> "ADM", 'fact_Time Sheet Line'[Chargeable] = 0)

the slicer would be selected to only show ADM

[donjek · Accepted 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!