Meaure with If statement

[dixia]

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 table

Sku	Store Count	Assortment
123433	1
343433	234
234355	1
565466	454
987971	1000

Thanks
Ding

[V-lianl-msft · Accepted solution]

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.

[az38]

Hi @dixia 

I thin there is enough to create a simpliest calculated column in your dimTable like

Assortment = IF([Store Count], "Online", "Instore")