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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Anonymous
Not applicable

percent of total for a calculated measure column

I need the percent of total for current years and prior years columns. I made a measure for Current years that works:

 

Sales % Total = 'Order_Line_Invoice'[SalesSUM]/CALCULATE(sum('Order_Line_Invoice'[Sales]),ALLSELECTED())

 

Prior year is a calculated measure: 

SalesPY =
CALCULATE (
Order_Line_Invoice[SalesSum],
SAMEPERIODLASTYEAR(Dates_INV[Date]))

 

I cannot make the Percent of Total for that. It will not let me apparently use my SalesPY measure in a Calculated Measure. 

 

Recommendations?

 

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.