Dax code check

[jochendecraene]

Hi

I have written this dax that gives me an indication when a value is bigger/smaller than the average. Now, I've adjusted the dax so that I get a warning when a value is 0.5% bigger/smaller than the average. 

It seems to do the job, but can someone have a check if this is correct? 

KPI UG =

Var _AverageByCat = CALCULATE(AVERAGE(W_MW_6[(MW_6)]),

ALLEXCEPT(W_MW_6[UG],W_MW_6[Year]))

return // _AverageByCat

IF(W_MW_6[(MW_6)] >= (_AverageByCat + 0.005), UNICHAR(128905), BLANK())

[Greg_Deckler]

@jochendecraene I don't see how this handles the smaller than .5% of average case.

[jochendecraene]

I thought I handled it by simpling adding 0.005 by the average?

IF(W_MW_6[(MW_6)] >= (_AverageByCat + 0.005), UNICHAR(128905), BLANK())

[Greg_Deckler · Accepted solution]

@jochendecraene Well that just checks if the current value is above .5% of the average, not if the value is .5% below the average. I would suggest using a SWITCH(TRUE(), ...) statement or you could do it via this:

IF(W_MW_6[(MW_6)] >= (_AverageByCat + 0.005) || W_MW_6[(MW_6)] <= (_AverageByCat - 0.005, UNICHAR(128905), BLANK())

[jochendecraene]

Yes, I see 

thnx!!!