Forum Discussion
Solved
Dax code check
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...
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 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())
Yes, I see
thnx!!!