counting rows which are not in slicer values

[liorro]

how can i count the IDs which are not included in slicer values?

for example, i want to count IDs which are not in time period between 15.2-18.2 (dynamic slicer values)

1	13.2
2	14.2
3	15.2
4	16.2
5	17.2
6	18.2

[Jihwan_Kim · Accepted solution]

Hi, @liorro 

Please check the below if it is what you are looking for.

The sample pbix file's link is down below.

CountID =
VAR mindate =
MIN ( DateTable[Date] )
VAR maxdate =
MAX ( DateTable[Date] )
RETURN
COALESCE (
CALCULATE (
COUNTROWS ( 'Table' ),
FILTER (
ALL ( DateTable ),
DateTable[Date] < mindate
|| DateTable[Date] > maxdate
)
),
0
)

https://www.dropbox.com/s/xn1a67wpa3e22s0/liorro.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.