Percentage total by total for that year, not total over multiple years

[Ruth_Smalley]

Hi,

First time poster so please be gentle!

I have a table of information covering multiple academic years.  Each line has a value of 'On campus' or 'Off campus'.  I use a date table to show the data by academic years.  

I have a table showing the % of use which is on of off campus:

The percentage is calculated with a formula 

Percentage usage = DIVIDE(COUNT(EZProxy[On/Off campus]),CALCULATE(COUNT(EZProxy[On/Off campus]),ALL()))

This work if I filter the chart to a single academic year, but I would like it to show the % on/off campus for each academic year, rather than totalling and working out the % across the total data (so 2020-21 would be 86% off and 14% on campus.

Any help appreciated!

Ruth

[parry2k]

@Ruth_Smalley glad to hear

[parry2k · Accepted solution]

@Ruth_Smalley try this:

Percentage usage = 
DIVIDE (
    COUNT ( EZProxy[On/Off campus] ),
    CALCULATE ( 
         COUNT ( EZProxy[On/Off campus] ),
         ALL(), 
         VALUES ( EZProxy[Academic Year] )
    )
)

[Ruth_Smalley]

Thank you so much for replying.  This has worked like a charm!

Ruth

[Greg_Deckler]

@Ruth_Smalley Try using ALLSELECTED instead of ALL