Measure for percentage of yearly totals

[sparker22]

I have 1 table with a column of continuous dates over 4 years, and a column of ages.

I want a measure that shows the percentage of each age group against the yearly totals, rather than total over the 4 years.

The current measures I have are:

        - COUNT(Table[Age])

        - COUNTROWS(ALL(Table) ...............  which gives me all rows rather than all rows per year

then - DIVIDE([AgeCount],[TotalCount])

Apologies for this probably simple question!

Many thanks.

[HashamNiaz · Accepted solution]

Hi !

You can use the following DAX measures to get desired output;

Age Count = COUNT(Employee[Age])

Total Age Count = CALCULATE([Age Count], ALLSELECTED(Employee[Age Group]))

% Age = DIVIDE([Age Count], [Total Age Count])

Regards,

Hasham

[sparker22]

This is great, thanks!

[Fowmy]

@sparker22 

If you can share some sample data and the expected result, it would be of great help.