Forum Discussion
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 the average.
It seems to do the job, but can someone have a check if this is correct?
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())
4 Replies
jochendecraene I don't see how this handles the smaller than .5% of average case.
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())
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())
