Help needed for DAX

Anonymous — Fri, 25 Aug 2023 10:21:29 GMT

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, 58,

[Pace Vs Goal] = 94, 64,

[Pace Vs Goal] = 95, 70,

[Pace Vs Goal] = 96, 76,

[Pace Vs Goal] = 97, 82,

[Pace Vs Goal] = 98, 88,

[Pace Vs Goal] = 99, 94,

[Pace Vs Goal] = 100, 100,

[Pace Vs Goal] = 101, 103,

[Pace Vs Goal] = 102, 107,

[Pace Vs Goal] = 103, 110,

[Pace Vs Goal] = 104, 113,

[Pace Vs Goal] = 105, 117,

[Pace Vs Goal] = 106, 120,

[Pace Vs Goal] = 107, 123,

[Pace Vs Goal] = 108, 127,

[Pace Vs Goal] = 109, 130,

[Pace Vs Goal] = 110, 133,

[Pace Vs Goal] = 111, 137,

[Pace Vs Goal] = 112, 140,

[Pace Vs Goal] = 113, 143,

[Pace Vs Goal] = 114, 147,

[Pace Vs Goal] = 115, 150,

[Pace Vs Goal] = 116, 153,

[Pace Vs Goal] = 117, 157,

[Pace Vs Goal] = 118, 160,

[Pace Vs Goal] = 119, 163,

[Pace Vs Goal] = 120, 167,

[Pace Vs Goal] = 121, 170,

[Pace Vs Goal] = 122, 173,

[Pace Vs Goal] = 123, 177,

[Pace Vs Goal] = 124, 180,

[Pace Vs Goal] = 125, 183,

[Pace Vs Goal] = 126, 187,

[Pace Vs Goal] = 127, 190,

[Pace Vs Goal] = 128, 193,

[Pace Vs Goal] = 129, 197,

[Pace Vs Goal] > 130, 200,

BLANK()

)

FYI:

[Pace Vs Goal] is a Measure having Percentage Format.

Whenever I am using the above DAX in Matrix , I am getting blank values against Pace Vs Goal column even when values is > 90.

Re: Help needed for DAX

some_bih — Wed, 23 Aug 2023 11:02:38 GMT

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

Re: Help needed for DAX

Anonymous — Fri, 25 Aug 2023 10:22:54 GMT

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

Re: Help needed for DAX

some_bih — Fri, 25 Aug 2023 10:40:58 GMT

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

topic Re: Help needed for DAX in DAX Commands and Tips

Help needed for DAX

Re: Help needed for DAX

Re: Help needed for DAX

Re: Help needed for DAX