Forum Discussion
Solved
Meaure with If statement
i am trying to write a DAX measure with if statement to return a value as assortment. if Store count =1, " Online", otherwise "Instore". both "SKU" and "Store count" are from the same dim - master...
Hi dixia ,
If your store count is not calculated by DAX, you need to use DAX to calculate the store count and then use if statement.
Try the DAX like this:
Assortment = IF(calculate(count(table[store]),allexcept(table(SKU)))=1, "Online", "Instore")Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
