Showing results for 
Search instead for 
Did you mean: 
New Member

Row level percentage calculation for a given year


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)))



Community Support
Community Support

HI @dajensen123 ,

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 


Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors