Check if all values in filters are selected (DAX)

[MohannadSh1996]

Hi,

Is there a way to check if all values in a specified filter are selected using DAX functions knowing that number of choices in filter are limited?

Thanks in advance 😊

[amitchandak · Accepted solution]

@MohannadSh1996 , not very clear.

Any value is filtered can be checked with isfiltered

example: if not filtered display 0 else count

Count Brant not all = if(ISFILTERED('Item'[Brand]),DISTINCTCOUNT('Item'[Brand]),0)

refer : https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[amitchandak · Accepted solution]

@MohannadSh1996 , not very clear.

Any value is filtered can be checked with isfiltered

example: if not filtered display 0 else count

Count Brant not all = if(ISFILTERED('Item'[Brand]),DISTINCTCOUNT('Item'[Brand]),0)

refer : https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[MohannadSh1996]

@amitchandak, I have tried it, it seems a good solution :), quick question please, do you know why i got 0 if i selected "Select All" in the filter? and how to return the number of all distnict values if "Select all" is choosen?

[MohannadSh1996]

@amitchandak & @Pragati11, to make the question more clear:

I want to check if Select All from a slicer is chooen?

[Anonymous · Accepted solution]

Hi @MohannadSh1996 ,

You can create a measure as below:

Count of selected items =
VAR _selClient =
    ALLSELECTED ( 'Table'[Client] )
RETURN
    CALCULATE ( COUNT ( 'Table'[Client] ), 'Table'[Client] IN _selClient )

You can also refer the contents in the following links to get it.

Get selected or multiple values from slicers using DAX

How to count how many items are selected on a Slicer

Best Regards

Rena

[Pragati11]

Hi @MohannadSh1996 ,

I didn't understand your question. Can you explain in detail with some screesnhots or sample data? Try sharing your DAX as well.

Thanks,

Pragati