Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
bozdemir
Frequent Visitor

Calculation (or Measures) for rows

Hello,

I have a table such as the following abd want to add the % row (last row), which is based on the two rows from the table.  Is there a way to do this?  Thanks very much.

Accounts Receivables AgingMonth 1Month 2Month 3
0-30 Day$7.0$11.0$12.0
31-60 Day$8.0$12.0$10.0
60+ Days$5.0$3.0$6.0
Current$30.0$34.0$12.0
Total Open Amount$50.0$60.0$40.0
    
60+Days past due as a % of total amount10.0%5.0%15.0%
1 ACCEPTED SOLUTION

Thanks, Stachu.  It worked. I did not have to follow all the steps you described.  But now, I have a measure that calculates the % I want.  Thanks again.

View solution in original post

2 REPLIES 2
Stachu
Community Champion
Community Champion

have a read here
https://community.powerbi.com/t5/Desktop/Create-calculated-row/td-p/440613



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Thanks, Stachu.  It worked. I did not have to follow all the steps you described.  But now, I have a measure that calculates the % I want.  Thanks again.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors