Forum Discussion

Winniethewinner's avatar
Winniethewinner
Helper IV
4 years ago

DAX help: switch selectedvalue not working

Hi everyone, I have a switch DAX. However when I add it to the visual, it shows "Can't display the visual":    Tickets_WOW_% = SWITCH(SELECTEDVALUE(Tickets_Measures[Name]), "Revenue", IF(AND(Tick...
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Winniethewinner ;

As Tamerj1 said, your first if() symbol is incorrect; You can modify it.

Secondly, all your if formulas are the same. Maybe you can try to simplify it.

Tickets_WOW_% =
IF (
    AND (
        Tickets_Measures[This Week] <> BLANK (),
        Tickets_Measures[Last Week] <> BLANK ()
    ),
    DIVIDE ( Tickets_Measures[This Week], Tickets_Measures[Last Week] ) - 1
)


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Winniethewinner's avatar
    Winniethewinner
    Helper IV
    4 years ago

    Thanks for the reply. I've changed the formula as you and tamerj1 suggested, however the WOW_% shows the $ instead %. 

    A bit more background, I used calculation group to switch the measures and its respective number format, where Rev shows $ format and count shows as decimal number format. 

    If I add FORMAT to Tickets_WOW_% formula and create a chart showing WOW% by dimension, the chart will not display. Any idea how to fix it? Thanks. 

    • tamerj1's avatar
      tamerj1
      Community Champion
      4 years ago

      Winniethewinner 

      Adding FORMAT will change it into a string. You need to chsnge the format manually to %

      • Winniethewinner's avatar
        Winniethewinner
        Helper IV
        4 years ago

        It doesn't work ☹️, and still shows as $.