Help With DAX for Nested IF Statements

[markefrody]

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.

[Bifinity_75]

@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")

[Bifinity_75 · Accepted solution]

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

[markefrody]

@Bifinity_75. Thanks!

[Bifinity_75]

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]

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