Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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 , 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")
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
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
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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |