Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
dixia
Employee
Employee

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 table

 

SkuStore CountAssortment
1234331 
343433234 
2343551 
565466454 
9879711000 

 

Thanks
Ding

1 ACCEPTED SOLUTION
V-lianl-msft
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
V-lianl-msft
Community Support
Community Support

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
Community Champion
Community Champion

Hi @dixia 

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

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

 


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.