Forum Discussion
if this column equal these values
Hi, I have this scenario, if this column equals these values then show the result. However, there is a blank entry of which I want it deleted. Here is the DAX column = IF(REQUISITION[Divisio...
Turka89 use filter or add a measure and display in the visual
measure = IF(MAX(REQUISITION[Division]) IN {"IT", "HR"}, MAX(REQUISITION[Division])
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Hi parry2k
Now only shows the blank entry when I use Max. It seems that when I spcifically chose values and I left other values will result in blank entry
Is there another way to do what I'm trying to achieve without IF statement?
Thank you so much