Showing results for 
Search instead for 
Did you mean: 
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:


       - 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

Community Support Team
Community Support Team

Re: Slicers, if statement, aglomerate



You may try the following condition.

    DISTINCTCOUNT ( Table1[country] ),
    Table1[region] = "Europe",
    ALL ( Table1[country] )
        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.