Show percentage against ALL for each legend item in a chart

[JamieH]

I am trying to create a chart that has a legend with 5 or 6 different items.  

The chart shows the percentage of an event occuring for each legend item, so you can have big swings in percentage.  I would like to show the percentage for each legend based on the total amount (i guess you would describe this as having the denominator being an unfiltered total amount, whilst the numerator is the filtered/legend amount).   Does anyone have any suggestions on how to do this?  

Here is the measure I am using to get the %:

1At3BalPct =

Var TotLoans = SUM('BackBook'[amounttofinance])

Var Tot1at3 =

        Calculate (

        SUM (  'BackBook'[amounttofinance]),

        Filter ('BackBook', 'BackBook'[Down1at3C] <> 0)

            )

Return

    Divide ( Tot1at3, TotLoans)

[DataInsights]

@JamieH,

Try this measure:

1At3BalPct =
VAR TotLoans =
    CALCULATE ( SUM ( 'BackBook'[amounttofinance] ), ALL ( 'BackBook' ) )
VAR Tot1at3 =
    CALCULATE ( SUM ( 'BackBook'[amounttofinance] ), 'BackBook'[Down1at3C] <> 0 )
RETURN
    DIVIDE ( Tot1at3, TotLoans )

[JamieH]

Thanks for this.

It doesnt quite work as the this measure is being pushed into a chart to show on a monthly basis, but the addition of the ALL ( Backbook ) means that it is dividing the monthly value for 'BackBook'[Down1at3C] <> 0 against the total EVER and not just by each of the months in the chart. 

Is there a way of adjusting this so it incorporates that date element?

[DataInsights · Accepted solution]

@JamieH,

I added a VALUES filter argument with a placeholder column name (replace with your actual date column name):

1At3BalPct =
VAR TotLoans =
    CALCULATE (
        SUM ( 'BackBook'[amounttofinance] ),
        ALL ( 'BackBook' ),
        VALUES ( 'Backbook'[Date Column] )
    )
VAR Tot1at3 =
    CALCULATE ( SUM ( 'BackBook'[amounttofinance] ), 'BackBook'[Down1at3C] <> 0 )
RETURN
    DIVIDE ( Tot1at3, TotLoans )

[JamieH]

Thank you, thats great.