Row level percentage calculation for a given year

[Anonymous]

Hello,

I have multiple years in my data set and need to calculate the total % by the indiviual row for that given year.  I've created a measure to give me the total for 2022, 2023.  However, when I create the meausure for the % each row will give me 1.00.  In reading about row calculations it looks like countrows needs to be in the measure.  When I've tried different things it returns a syntax error.  

2022 % Status Reason = DIVIDE([Total Reasons 2022],COUNT('Table 1 (Export)'[Status Reason]))

tried this below

2022 % Status Reason = DIVIDE([Total Reasons 2022], COUNTROWS(FILTER('Table 1 (Export)', YEAR('Table 1 (Export)'[Date]) = 2022)))

Thanks

[v-shex-msft]

HI @Anonymous ,

It seems like a common issue when measure expression calculates on multiple level aggregates. I’d like to suggest you can refer to the Greg’s blog to add a variable with SUMMARIZE function to handle the first level and use iterator function to apply the second level.

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng