Select measure when month is selected

[Anonymous]

Hi all, 

I would like to create a measure that says show all when no slicers are selected but when one slicer is selected, then show a measure. how would I do that? 

Thanks in advance! 

[selimovd · Accepted solution]

Hey @Anonymous ,

try the following approach:

myMeasure =
IF(
    ISFILTERED( myTable[Slicer] ),
    [Measure when selected],
    [Measure for ALL]
)

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

First create a calculated table(Slicer) to summarize the slicer field(Product), then use the summarized field to create the slicer.
Then we create a measure and filter the measure in the filtering pane.

_isShow =
IF (
    ISFILTERED ( Slicer[Product] ),
    IF ( MAX ( 'financials'[Product] ) IN VALUES ( Slicer[Product] ), 1, 0 ),
    1
)

And the another measure what you need would be like this:

_Slicer = 
IF(ISFILTERED(Slicer[Product]),[Measure when selected],[Measure for ALL])

sample:

Please refer to the attachment below for details

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[selimovd · Accepted solution]

Hey @Anonymous ,

try the following approach:

myMeasure =
IF(
    ISFILTERED( myTable[Slicer] ),
    [Measure when selected],
    [Measure for ALL]
)

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic