DAX for percent of stacked column (only column not GT) with date hierarchy

[EAPCGF]

I have a stacked column chart with two categories in the series/legend (under 65 and over 65). It shows a count of people in each of the two series.

I also have a date heirarchy on the x axis.

I need the series to display data labels showing count AND percent of total for each column (not percent of grand total). 

I have created a measure using DAX to calculate the percent of total and added this to the detail section of the data labels. This works well for a single stacked column, but when I add the date heirarchy it shows percent of grand total, not percent of each column.

What DAX can I use to get percent of series in each column? ie numerator - series, denominator total for both series in that month/quarter/year.

or is there another way to do this?

Thanks

Percent Stream2 =

DIVIDE(

    DISTINCTCOUNT(Table1[ID] ),

    CALCULATE(

        DISTINCTCOUNT(Table1[ID] ),

        ALLSELECTED()

    )

)

[DataInsights · Accepted solution]

@EAPCGF,

This solution assumes that your model has a date table (best practice). The concept is to keep the Month filter context while clearing all other filters originating within the visual.

Percent Stream2 =
DIVIDE (
    DISTINCTCOUNT ( Table1[ID] ),
    CALCULATE (
        DISTINCTCOUNT ( Table1[ID] ),
        ALLSELECTED (),
        VALUES ( 'Date'[Month] )
    )
)

[DataInsights · Accepted solution]

@EAPCGF,

This solution assumes that your model has a date table (best practice). The concept is to keep the Month filter context while clearing all other filters originating within the visual.

Percent Stream2 =
DIVIDE (
    DISTINCTCOUNT ( Table1[ID] ),
    CALCULATE (
        DISTINCTCOUNT ( Table1[ID] ),
        ALLSELECTED (),
        VALUES ( 'Date'[Month] )
    )
)

[EAPCGF · Accepted solution]

Perfect! Thank you 🙂