Count the number of items in a slicer

[johnyip]

How do I count how many items are available (not how many items I have selected) in a slicer? I need to store it in a variable or measure, so that I can use the value for future use.

Update:

My slicer is something like Market_Slicer in this file:
https://drive.google.com/file/d/1SWSzCKiwckuAr2woo_LeTi2GecsnWlPF/view?usp=sharing

The total number of items varies, depending on choices of another slicer (Company_Slicer).

[johnyip · Accepted solution]

I managed to find another workaround recently, it is to use ISFILTERED(). I can avoid all the messy variables by using it.

Thanks for all the replies.

[PaulDBrown]

Ok, try:

Avaailable =
VAR _All = CALCULATE (DISTINCTCOUNT (Fact table [Slicer field]), ALL(Fact table ))

RETURN

_All - DISTINCTCOUNT(Fact Table[Slicer field] )

[PaulDBrown]

Try:

available = IF(ISFILTERED ( Table slicer), COUNTROWS (ALL(Table Slicer)) - COUNTROWS (VALUES(Table Slicer [Column])), COUNTROWS (ALL(Table slicer)))