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...
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.

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