Forum Discussion

BarrbC's avatar
BarrbC
Frequent Visitor
7 years ago
Solved

Calculate scores - intervals

hello,   I'm struggling with  calculating scoring for my dashboard. There is a number describing the target which a respective representative has reached. Depending on the score it should be catego...
Need Help
Tutorial Requests
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    BarrbC Please change the formatting for the field to "Percentage" instead of text type. Then use the below DAX as new column.

     

    Score = SWITCH(TRUE(),Test41Switch[Sales]<0,1
		             ,Test41Switch[Sales]*100<=80,2
                     ,Test41Switch[Sales]*100<=95,3
                     ,Test41Switch[Sales]*100<=100,4
                     ,Test41Switch[Sales]*100>100,5
              )

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

BarrbC Please change the formatting for the field to "Percentage" instead of text type. Then use the below DAX as new column.

 

Score = SWITCH(TRUE(),Test41Switch[Sales]<0,1
		             ,Test41Switch[Sales]*100<=80,2
                     ,Test41Switch[Sales]*100<=95,3
                     ,Test41Switch[Sales]*100<=100,4
                     ,Test41Switch[Sales]*100>100,5
              )