Forum Discussion

DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
4 years ago
Solved

Count Items not in the slicer

Here is my example model   And I wanted to see for example Reports not in the Date slicer the table contains for example reportName and the measure created with this DAX   Is Not in t...
Need Help
  • DebbieE's avatar
    DebbieE
    4 years ago

    I think I may have sussed it

     

    Total Reports not in date Filter =
    //Clear all filters which are applied to the specified table.ALLCROSSFILTERED
    var VAllReports =CALCULATE([# reports],ALLCROSSFILTERED(DimDate))
    //Total within the date filter
    var VInFilter = [# reports]
    //All reports - Reports inside the slicer
    Return VAllReports-VInFilter
Anonymous's avatar
Anonymous
Not applicable
4 years ago

DebbieE 
ALLEXCEPT in measures do not work as same in calculate columns. Glad you solved.

 

 

Paul Zheng _ Community Support Team