Forum Discussion

Winniethewinner's avatar
Winniethewinner
Icon for Helper IV rankHelper 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
Icon for Community Support rankCommunity 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
Icon for Helper IV rankHelper 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
    Icon for Community Champion rankCommunity 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
      Icon for Helper IV rankHelper IV
      4 years ago

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