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 August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Using the Total of a measure in another measure/calculation

How can I use this Total highlighted below in another Measure/Calculation?

 

This is my measure

 

PLIQ Rolling =

CALCULATE(SUM('NetSuite_P&L_Monthly'[Paint Liquids Rolling 12]), DATESINPERIOD(DateDimension[Date],
LASTDATE(DateDimension[Date]),-12,Month
)
)

measure-total.png

 

The next step is to divide this Total number by how many months make it up which I have done inside the measure unfortunately it divides each row by the total number of months instead of just the total 😞

3 REPLIES 3
Anonymous
Not applicable

Hi,

 

I am unsure about the Months Calculation that you have mentioned, But if you require to divide the Total SUM then use the calculation :

CALCULATE(SUM(Rolling_Sum),ALL(Table_Name))

Anonymous
Not applicable

Will do thanks. I think I got my answer anyway

v-anabat
Microsoft Employee
Microsoft Employee

Hi, 

 

Please always prvoide some sample data in either text or table format along with snippets. A snippet doesn't alow the users to copy the data readily and and do a qucik analysis.So it may reduce the probability of your question being answered. 

 

Regards,

Ananth

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.