Percent of grand total, by X Axis

[lewisgrantevans]

Hi all,

I know this question has been asked in a number of ways but i can't get the other answers to work for me.

I have this graph -

Using these fields -

For Values, I am using percent count of grand total, but i need this to calculate percent count per Quarter/Year, so 2020 Q1 has these percentage values -

I understand from pervious responses that I need to create a Measure, potentially using the following formula -

Measure =

DIVIDE (

    CALCULATE ( 

       SUM ( Table[Amount] ),

        ALLSELECTED ( Table ),

        VALUES ( Table[Role] ),

        VALUES ( Table[Date] )

    ),   

CALCULATE ( SUM ( Table[Amount] ), ALLSELECTED ( Table ) )

)

I have tried putting my field names into this formula but unfortunately I cannot get this to work. Could someone please help a relative novice?

Thanks!

[Fowmy]

@lewisgrantevans 

You use a 100% stacked column chart instead of a line chart. The chart will do the calculation  for you.

[lewisgrantevans]

The 100% stacked column chart certainly gives me the correct percentages but i need to visualise it with a line chart, like this -

This is one of the most basic excel charts and it's a shame there is no Power Bi equivalent. Do you think I can achieve this with a Measure?

[Fowmy · Accepted solution]

@lewisgrantevans 

Try this measure:

Measure =
DIVIDE (
    SUM ( Table[Amount] ),
    CALCULATE ( 
        SUM ( Table[Amount] ),   
        ALLSELECTED(Table[Turnaroundtime])  
    )
)