Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys,
I am stuck on what should be a pretty straight forward dax measure. I am hoping I can get some clarity on how the percentages work in Power BI. Here is my table:
Marble Color | Previous Amount | Recovered | Processed |
Blue | 200 | 20 | 50 |
Green | 300 | 40 | 120 |
Red | 150 | 10 | 100 |
Yellow | 100 | 30 | 60 |
I am calculating the recovery rate as follows:
What I would like the "Total Projection" card to return instead is (80 + 100 + 15 + 50) = 245
Solved! Go to Solution.
Hey,
Try using SUMX:
Hey,
Try using SUMX:
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |