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 calculate column:

Result = if ('Table'[Classification]="Toys" && 'Table'[Quality Check?]="Yes" && 'Table'[Safety Check?]="Yes",25,
            if ('Table'[Classification]="Appliances" && 'Table'[Quality Check?]="Yes" && 'Table'[Price Check?]="Yes",130,
            0))

 

The result:


Check your conditions for if statements.

 

Best regards

 

 

  • markefrody's avatar
    markefrody
    Post Patron
    3 years ago

    Hi Bifinity_75 ,

    Thank you for the response and assistance. I may have confused you with the conditional statements wherein I have mentioned the weight number. I have removed it, below is the corrected one:

    Weight for products classified as "Toys" which has "Quality check = Yes" and "Safety check = Yes" 

    +

    Weight for products classified as "Appliance" which has "Quality check = Yes" and "Price check = Yes" 

    =

    Grand Total weight (lbs) of the filtered conditions