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 a table that contains funds that have a group name and a value. I'm trying to calculate what each funds percentage is of it's group. So, the table would look like this:
Code Pool Value
A 1 10.00
B 1 20.00
C 1 30.00
D 2 50.00
E 2 60.00
F 1 10.00
So, for each pool I want to have the percentage value for each code so that I can dispaly it in a donut chart.
Any help would be greatly appreciated!
Thanks.
Solved! Go to Solution.
Here's the Measure that will do this
Measure = DIVIDE ( SUM ( 'Table'[Value] ), CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table'[Code] ) ), 0 )
And the results...
Hope this helps!
Here's the Measure that will do this
Measure = DIVIDE ( SUM ( 'Table'[Value] ), CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table'[Code] ) ), 0 )
And the results...
Hope this helps!
Hi @Sean
That looks really good, thanks! Could I ask you a quick question re donut charts? I have a stacked column chart showing all the pools summing the value of each code (which is a pretty standard chart). I'd like to have a donut chart next to it that when someone clicks on one of the columns in the chart, shows the breakdown of each code for that pool (hence the question re the calculation).
When I create a donut chart it seems to be showing every column in the chart rather than just the one I click on. Is that possible or do donut chatrs not work that way?
Thanks!
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 |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |