cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jorgegarioli Frequent Visitor
Frequent Visitor

Slicers, if statement, aglomerate

Hello everyone,

I want to know if there is a way to create (maybe using DAX) an IF statement that when I select all options within my slicer, a new label appears as LEGEND of my graphs.

For example, I have a hierarchy slicer like this:

-Europe

       - France

       - Portugal

       - Italy

          ...

If I select all the countries I want the label in my graphics to be Europe and not each separated country.

Thank you

1 REPLY 1
Highlighted
Community Support Team
Community Support Team

Re: Slicers, if statement, aglomerate

@jorgegarioli,

 

You may try the following condition.

CALCULATE (
    DISTINCTCOUNT ( Table1[country] ),
    Table1[region] = "Europe",
    ALL ( Table1[country] )
)
    = CALCULATE (
        DISTINCTCOUNT ( Table1[country] ),
        Table1[region] = "Europe",
        ALLSELECTED ( Table1[country] )
    )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.