Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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.
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.
User | Count |
---|---|
134 | |
68 | |
67 | |
54 | |
52 |
User | Count |
---|---|
207 | |
95 | |
64 | |
61 | |
57 |