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
v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Chanleakna123 ,

but this is exeption :  IF 1317 count 1 and 1108 count 1 both of them will count  only 1 , 

IF 4295 count 1 and 2239 count 1 both of them will count only 1 

For the rest let's calculate as normal sum. 

I could not figure out how could you count the number? Could you please post your desired result if possible?

 

Regards,

Daniel He

  • 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)

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

      v-danhe-msft  , hi you get what i mean ? Or do i need more explanation to acheive this ? 
      Your response is really a big help now to my side. 

    • 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