Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Help needed for DAX

Payout Percentile Projection = SWITCH(     TRUE(),     [Pace Vs Goal] < 90, 0,     [Pace Vs Goal] = 90, 40,     [Pace Vs Goal] = 91, 46,     [Pace Vs Goal] = 92, 52,     [Pace Vs Goal] = 93, ...
some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous why FALSE in the start? Try to debug part BLANK() with someting like 9999999 etc.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I'm using TRUE(), after replacing BLANK() I am getting result as 0

    • some_bih's avatar
      some_bih
      Icon for Community Champion rankCommunity Champion
      3 years ago

      Hi Anonymous card result could be "result" of interaction of other visuals on canvas, like slicer...