Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
80 | |
61 | |
60 | |
58 |
User | Count |
---|---|
155 | |
119 | |
104 | |
78 | |
71 |