Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Having a dynamic measure depending on different selections

Hi, I’m trying to create a conditional measure depending on slicer choices. I have three categories: Culture, Studies and Other.   For Studies and Other, I’m counting study hours. But for Cultur...
  • Adescrit's avatar
    5 years ago

    Create a new table using Enter Data in the data view of Power BI desktop. In this table create two columns "Metric" containing your desired slicer options (Culture, Studies, Other) and an "Index" column containing the numbers 1 to 3. Using the Enter Data option means you can just type all this in. Name the table "Metric Selection".

    In this new table create a measure:

     

     

    Selected Metric = SELECTEDVALUE( 'Metric Selection'[Metric] )

     

     

     

    Now you can create a measure that allows the user to toggle between the measures you have already created, depending on what they select from a slicer:

     

     

     

    Culture, Studies Other Selection = 
        SWITCH( TRUE() ,
            'Metric Selection'[Selected Metric] = "Culture", [Culture Occasions],
            'Metric Selection'[Selected Metric] = "Studies", [Study hours]
        )

     

     

     

    You can use this measure in the values section of your charts, graphs and cards.