Slicers, if statement, aglomerate

[Anonymous]

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

[v-chuncz-msft]

@Anonymous,

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] )
    )