Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am creating a cluseterd bar chart in which I have unpivoted two columns (Internal FTE's % and External FTE''s %), so that they can be shown seperately with their own bars
Before
After
After doing so I have created my cluseterd chart and everything looks fine, however when I put my value% as a grand total it is giving me the grand total of both the Internal and External FTE's instead of a Grand total of 100% each
How can I get a grand total of a 100% for each the Internal and External FTE?
Solved! Go to Solution.
Hi @walker8888 ,
You could create a measure as values.
Measure =
DIVIDE (
CALCULATE (
SUM ( 'Table'[Value] ),
FILTER (
ALLSELECTED ( 'Table' ),
[Attribute] = MAX ( 'Table'[Attribute] )
&& [Priority] = MAX ( 'Table'[Priority] )
)
),
CALCULATE (
SUM ( 'Table'[Value] ),
FILTER ( ALLSELECTED ( 'Table' ), [Attribute] = MAX ( 'Table'[Attribute] ) )
)
)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @walker8888 ,
You could create a measure as values.
Measure =
DIVIDE (
CALCULATE (
SUM ( 'Table'[Value] ),
FILTER (
ALLSELECTED ( 'Table' ),
[Attribute] = MAX ( 'Table'[Attribute] )
&& [Priority] = MAX ( 'Table'[Priority] )
)
),
CALCULATE (
SUM ( 'Table'[Value] ),
FILTER ( ALLSELECTED ( 'Table' ), [Attribute] = MAX ( 'Table'[Attribute] ) )
)
)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
What if I had 3 more bars that I wanted to show seperately, so in all that would be 5
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |