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:

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 of the filtered conditions


Would you be able to assist me to create a DAX based on the conditions above and be presented with an output similar to this?



PS: I'm using Direct Query as storage mode.

Thanks and best regards,
Mark V.

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

     

     

5 Replies

  • 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

     

     

  • 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




  • Bifinity_75's avatar
    Bifinity_75
    Solution Sage
    3 years ago

    markefrody , change the previous measure to this one:

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