Forum Discussion

Chanleakna123's avatar
Chanleakna123
Icon for Post Prodigy rankPost Prodigy
7 years ago

Dax Help on Condition IF or OR

Hi everyone . i'm working on Condition dax which a bit complicate over here and i have never experienced this before.  We have code , must have SKU etc.. and Count. in this case , BI will count all...
Tutorial Requests
Chanleakna123's avatar
Chanleakna123
Icon for Post Prodigy rankPost Prodigy
7 years ago

HI v-danhe-msft  really thanks for your response , 

 

I have the calculation in Excel as per yellow highlight , 

 

i have  different code numbers , and you see Green Column , means the calcuation of below. 

 

ANY Coke 1.5L OR 2.25L =IF(OR(V5=1,W5=1),1,0)

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Chanleakna123 ,

It seemed your formula could work normally in Power BI, could you have tried it? Below is my test formula:

AD = IF(OR([AB]=1,[AC]=1),1,0)

Result:

 

Regards,

Daniel He