Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |