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 the following data set:
Area Item Cost
1 Yes 5
1 Yes 10
1 No 20
2 No 12
2 Yes 13
2 Yes 12
How do I achieve the following:
Sum of cost where Item is "yes" divided by Sum of cost with both "yes" and "no"?
It should be so easy, but I am afraid I simply can't crack it, and it is rather urgent.
Thank you in advance,
And happy holidays 😄
Solved! Go to Solution.
Hi,
Try this
=CALCULATE(SUM(Data[Cost]),Data[Item]="Yes")/SUM(Data[Cost])
Hope this helps.
Hi @Crav888,
Another try:
Measure = CALCULATE ( SUM ( 'table3'[Cost] ), 'table3'[Item] = "Yes" ) / CALCULATE ( SUM ( table3[Cost] ), ALL ( table3[Item] ) )
Best Regards,
Dale
Hi,
Try this
=CALCULATE(SUM(Data[Cost]),Data[Item]="Yes")/SUM(Data[Cost])
Hope this helps.
Hi @Crav888,
You have to create Measure with FIlter then like below,
Measure Sum of Yes = CALCULATE(SUMX(Table3,Table3[Cost]),FILTER(Table3,Table3[Item]="YES")) Measure Sum of NO = CALCULATE(SUMX(Table3,Table3[Cost]),FILTER(Table3,Table3[Item]="NO")) Divide measure = ([Measure Sum of Yes]/([Measure Sum of Yes]+[ Measure Sum of NO]))
If it works, Please Like(kudo) my answer and accept as solution.
Regard,
Mehbub
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |