How to get grand total to exclude 1 filter

[Alicia_Anderson]

Below is a simplistic view of the data:

The goal is to exclude rows from displaying in the above table where #Calls <50, which I can easily do with a filter.  However, I need the GT Logical Reads to INCLUDE all Calls.    

This is my measure, but it is not working.  

Any assistance is appreciated!

[Alicia_Anderson · Accepted solution]

I was able to accomplish this by setting the values for all the slicers and then removing the one. 

[Alicia_Anderson]

All works EXCEPT it gives me the total for all the data.  I want the total calculated based on all the selections made which can include multiple filters on Customer, Date and Object.

[KNP]

Hard to say definitively with the information provided, maybe something like...

_GT_LogReads =
CALCULATE (
    [_LogRead],
    REMOVEFILTERS ( DMV[NumberOfCalls] )
)

If REMOVEFILTERS doesn't work for you, investigate ALLEXCEPT.

[Greg_Deckler]

@Alicia_Anderson Try using ALL instead of ALLSELECTED