Calculate Total of a Field while Ignoring X Axis

[NewAnalyst16]

Hi,

I am currently trying to calculate the Running Total of Customer Contract Renewals in terms of percentage of total Contracts, and how that trends by Date. Currently, I have figured out a calculation that shows volume of renewals by date ([Days Until Expiry]):

Renewed RCE running total in Days Until Expiry =

CALCULATE(

    SUM('Residential - US South'[Renewed RCE]),

    FILTER(

        ALLSELECTED('Residential - US South'[Days Until Expiry]),

        ISONORAFTER('Residential - US South'[Days Until Expiry], MAX('Residential - US South'[Days Until Expiry]), DESC)

    )

)

However, I want to view these not in raw number totals but in percentage totals (and compare customer cohorts as the legend). Logically, I get how to calculate this: just divide the running total by the grand total by cohort which should show how that percentage gets closer to 100% over time. 

I'm running into an issue, however where that "Grand Total" I try and calculate gets affected by the X axis so instead of showing the grand total for every day in March (for example), on March 1st it shows the grand total for March 1st, March 2nd for March 2nd, etc.

So how do I create this calculation which displays the same value for every day in a month, regardless of the X axis?

Thanks!

[amitchandak · Accepted solution]

@NewAnalyst16 , Not very clear.

% can be

Renewed RCE running total in Days Until Expiry  %=

divide( CALCULATE(

    SUM('Residential - US South'[Renewed RCE]),

    FILTER(

        ALLSELECTED('Residential - US South'[Days Until Expiry]),

        ISONORAFTER('Residential - US South'[Days Until Expiry], MAX('Residential - US South'[Days Until Expiry]), DESC)

    )

),CALCULATE(
SUM('Residential - US South'[Renewed RCE]),
ALLSELECTED('Residential - US South'[Days Until Expiry])))

Can you share sample data and sample output in table format?

[NewAnalyst16]

Incredible Amit, thanks a ton!