undefined

[walker8888]

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? 

[Anonymous · Accepted 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.

[walker8888]

What if I had 3 more bars that I wanted to show seperately, so in all that would be 5