Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to create a measure for % of total by Site. % of Grand Total can use built-in functionality so no work there, but what is the logic to break it down to an attribute level?
Tried this but it doesn't work: DIVIDE(SUM('Main'[Amount]),CALCULATE(SUM('Main'[Amount]),ALLEXCEPT('Main','Main'[Site])))
Hi @smileamile2 ,
I used your formula and get the result as shown in your screenshot. What is the expected result?
Best Regards,
Jay
Hey @smileamile2 ,
can you show your result in Power BI?
The values for % of total by site look good, but I guess that's Excel.
What is the result for the calculate-part:
CALCULATE(SUM('Main'[Amount]),ALLEXCEPT('Main','Main'[Site]))
Most results are 0%, only adding up to a total of 9.71%. I only included the excel spreadsheet as the desired outcome sample.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |