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.
