Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Grouping Multiple DAX measures into categories

Hi - saw a really good video over here: https://www.youtube.com/watch?v=iH3gW_vy69o It gives a good insight into dynamically creating groupings. What i'm after though is to group multiple measur...
Interesting Links
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    HI Anonymous

     

     

    Using a Switch Statement over your measures might be the way to go.  Something along the lines of...

     

     

    New Measure = 
    SWITCH(
            True() ,
            [Measure1] >= 6 && [Measure2] > 99 && [Measure3] > 80 , "Gold" ,
            [Measure1] >= 4 && [Measure2] > 95 && [Measure3] > 75 , "Silver" ,
            [Measure1] >= 2 && [Measure2] > 90 && [Measure3] > 50 , "Bronze" ,
            "Other" )

     

     

     

     

     

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

HI Anonymous

 

 

Using a Switch Statement over your measures might be the way to go.  Something along the lines of...

 

 

New Measure = 
    SWITCH(
        True() ,
        [Measure1] >= 6 && [Measure2] > 99 && [Measure3] > 80 , "Gold" ,
        [Measure1] >= 4 && [Measure2] > 95 && [Measure3] > 75 , "Silver" ,
        [Measure1] >= 2 && [Measure2] > 90 && [Measure3] > 50 , "Bronze" ,
        "Other" )

 

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Excellent Phil_Seamark works perfectly! 

     

    Thank you