Forum Discussion

walker8888's avatar
walker8888
Helper II
3 years ago
Solved

undefined

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? 

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      walker8888
      Helper II
      3 years ago

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