Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |