Forum Discussion

WNelson's avatar
WNelson
Frequent Visitor
2 years ago
Solved

Score Card using symbols

Really needing an expert on this one..... I am creating a score card that I have pulled off You Tube.  I have the sample BI to copy and have benn doing great until now.  I am  trying to add a symbol...
  • sevenhills's avatar
    sevenhills
    2 years ago

    I think you have % part of the text/value. Try this.

    SelectItem = 12 && (VALUE( SUBSTITUTE([Classic prioritizes overall safety],"%","") ) / 100) >= 0.90

     
    Tested:

     

    Column2 is calculated column and its syntax:

     

    Measure syntax:

     

     

    I was doing fast copy paste and has to do multiple edits in this reply. 🙂

WNelson's avatar
WNelson
Frequent Visitor
2 years ago

sevenhills 

Nope this is the error that I get.  

The syntax for 'SelectItem' is incorrect. (DAX(VAR SelectItem = SELECTEDVALUE('KPI Score Card'[Row Index])ReturnSWITCH(TRUE(),SelectItem IN {1,9,13,17}, "",SelectItem = 2 && [Overall Sastifaction 2024] <= 4.5,"▲",SelectItem = 2 && [Overall Sastifaction 2024] > 4.5,"▼",SelectItem = 5 && [2024 Overall Employee Sat] >= 4.5,"▲",SelectItem = 5 && [2024 Overall Employee Sat] >= 4.5,"▼",SelectItem = 6 && [Client agree needs met] < 90,"▼",SelectItem = 6 && [Client agree needs met] >= 90,"▲",SelectItem = 5 && [Overall Sastifaction with current position] < 4.5,"▼",SelectItem = 7 && [CP Communication with Classic] >= 4.5,"▲",SelectItem = 7 && [CP Communication with Classic] < 4.5,"▼",SelectItem = 10 && [Attention to safety] >= 4.5,"▲",SelectItem = 10 && [Attention to safety] < 4.5,"▼",SelectItem = 12 && Value([Classic prioritizes overall safety]) >= 0.90SelectItem = 22 && [2024Touchpoints] <= 152,"▼",SelectItem = 22 && [2024Touchpoints] > 152,"▲",UNICHAR(9724)))).