Count Items not in the slicer

[DebbieE]

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 the Date Filter Flag =

// assumes DimReport[Report] is in the visual

// assumes a slicer on DimDate[ActivityDateKey]

VAR VActivityDates = SELECTCOLUMNS(DimDate,"Dates", DimDate[DateKey])

VAR VDates = CALENDAR(MINX(DimDate,DimDate[DateKey]),MAXX(DimDate,DimDate[DateKey]))

RETURN

IF(COUNTROWS(INTERSECT(VActivityDates,VDates)),0,1)

// if no matching rows, return 1

this is fantastic and works as you can see above. I use it for both reports and datasets. However I would like to Count the number of reports not used this month. And count the number of DataSets not used this month and I havent managed to figure out how to do this yet. Whether I sit something on top of this DAX or Create New DAX measure.

I tried 

Total Reports not in date Filter = CALCULATE([# reports],ALLEXCEPT(DimDate,DimDate[DateKey]))

But I get back 4  (All of them) and not the 2 that are outside of the September Filter

Any ideas would be great

[Anonymous]

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

Paul Zheng _ Community Support Team

[DebbieE · Accepted solution]

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