Forum Discussion

JoanCampbell's avatar
JoanCampbell
Frequent Visitor
5 years ago
Solved

IF statement for 3 criteria

Value = IF(AND((Merchandising[Merchandizing Type]="Pack out to shelf" || Merchandising[Merchandizing Type]="Pack out to Exsisting Display"||Merchandising[Merchandizing Type]="Pack out to new display"...
Need Help
  • TomMartens's avatar
    TomMartens
    5 years ago

    Hey JoanCampbell ,

     

    if you are using the DAX and want to use AND then you have to write your DAX like so:

    ...
IF(
AND( AND( condition1 , condition2 ) , condition3 )
, TRUE branch
, FALSE branch
)
...

    using DAX this will work as well, keep in mind that || means OR and && means AND

    ...
IF(
( condition1 && condition2 && condition3 )
, TRUE branch
, FALSE branch
)
...

     

    Hopefully, this provides the missing link, and helps to tackle your challenge.

     

    Regards,

    Tom

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi JoanCampbell ,

 

This is a sample of data that I understand, I don't know if it's right.

From the data on the figure, only [Qty] and [Price] of A can be multiplied.

 

You should copy a category column first, and then pivot table as follows.

 

 

Measure

Measure = IF(CALCULATE(DISTINCTCOUNT(Merchandising[Merchandizing Type]),ALLEXCEPT(Merchandising,Merchandising[Category]))=3,MAX('Merchandising'[Qty])*MAX('Merchandising'[Price]))

 

Calculated column

Column = IF(CALCULATE(DISTINCTCOUNT(Merchandising[Merchandizing Type]),ALLEXCEPT(Merchandising,Merchandising[Category]))=3,[Qty]*[Price])

 

If my understanding is wrong, provide some sample data and expected results?

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.