Forum Discussion

markefrody's avatar
markefrody
Post Patron
3 years ago
Solved

Help With DAX for Nested IF Statements

Hi,  I have this table:   For example I want to get the weight of the following items with the following conditions and add them to another item with a set of different conditions: We...
Need Help
  • Bifinity_75's avatar
    Bifinity_75
    3 years ago

    Hi markefrody , try this MEASURE:

     

    Result = CALCULATE(sum(Table3[Weight (lbs)]),Table3[Classification]="Toys",Table3[Quality Check?]="Yes",Table3[Safety Check?]="Yes")+
CALCULATE(sum(Table3[Weight (lbs)]),Table3[Classification]="Appliances",Table3[Quality Check?]="Yes",Table3[Price Check?]="Yes")

     

    The result:

     

    Best Regards

     

     

Bifinity_75's avatar
Bifinity_75
Solution Sage
3 years ago

Hi markefrody , try this MEASURE:

 

Result = CALCULATE(sum(Table3[Weight (lbs)]),Table3[Classification]="Toys",Table3[Quality Check?]="Yes",Table3[Safety Check?]="Yes")+
CALCULATE(sum(Table3[Weight (lbs)]),Table3[Classification]="Appliances",Table3[Quality Check?]="Yes",Table3[Price Check?]="Yes")

 

The result:

 

Best Regards