Chiclet slicer selections - measure to test

[Anonymous]

Hi all,

I am using the Chiclet slicer with two possible options (A, B) but using the Multiple Selection setting = ON and the Forced Selection setting = OFF.

I want to show the items that match on another table on the page.

This gives me four possibilities with the following required outputs 

A on, B on - show all values 

A on, B off - show just values where ColumnName = A

A off, B on - show just values where ColumnName = B

A off, B off - show nothing

Using IF( HASONEFILTER( ColumnName), COUNTROWS(etc etc), BLANK() ) enables me to achieve the last 3, but the first one  (A on, B on) gives me no values. Same if I use HASONEVALUE().

If I have no wrapper function (i.e. just have COUNTROWS(etc etc) as the measure), then the first 3 work, but the last one (A off, B off) shows all the values.

Thanks in advance. 

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

Please try this formula:

Sales measure =
IF (
    ISFILTERED ( 'TableName'[ColumnName] ),
    COUNTROWS ( 'TableName'),
    BLANK ()
)

Best regards,
Yuliana Gu