Forum Discussion
Chanleakna123
Post Prodigy
7 years agoDax 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...
Chanleakna123
Post Prodigy
7 years agoHI All ,
Can somebody helps me using Dax over IF & OR ,
I have Code , Material Description , Count and Customer Code & Name ,
* You see the Code number 4223 count 1 , and 1300 Count 1 ,
If i Visualize customer code with Code number and count columns , these will sum up together Total : 2
*But i wanna set Condition , If 4223 Count 1 , 1300 Count 1 , Total 1 only
and this is the calculation i used on Excel Total =IF(OR(V5=1,W5=1),1,0)
For the rest let's calculate as Normal Sum
and i have repeatedly Code number to be repeadted on Excel . Can i cook this in BI ?