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
Anonymous
Not applicable

How to use a result of a measure in another measure

Hi there, 

 

It's my first post here. I hope this will find you well. 

I've created a measure which calculates the percentage of the costs.

Now I want to use these percentages to calculate the Turnover per employee according to their costs. How can I use the result of  a measure in another measure? 

Cost in % = 

VAR CurrentOrder = Values(expensepostings[order_id])
VAR CurrentSuborder = Values(expensepostings[suborder_id])
VAR TotalCosts =
SWITCH(
    TRUE(),
    ISINSCOPE(employees[display_name]), CALCULATE(SUM(expensepostings[cost_amount]), ALLSELECTED(expensepostings), expensepostings[order_id] IN CurrentOrder, expensepostings[suborder_id] in CurrentSuborder),
    ISINSCOPE(expensepostings[suborder_id]), CALCULATE(SUM(expensepostings[cost_amount]), ALLSELECTED(expensepostings), expensepostings[order_id] IN CurrentOrder),
    ISINSCOPE(expensepostings[order_id]), CALCULATE(SUM(expensepostings[cost_amount]),ALLSELECTED(expensepostings))
)
RETURN
IF(
    ISINSCOPE(expensepostings[order_id]),
        DIVIDE(expensepostings[Gesamtkosten], TotalCosts),
    1
)
 
Depending on which level I am this measure will calculate the percentage of costs according to the order_id, the suborder_id or the employee name. The result on employee level is shown here: 

Pii_0-1705588168543.png

 

Now I have the percentages from each employee per suborder. I want to use these percentages to calculate the turnover for each employee per suborder.  In the order table I have the information that suborder 19790 has a turnover of 875. But I don't know how to use the calculated percentages. 

I would like to excpect the turnover for each employee per suborder like this: 

Pii_2-1705589201910.png

 

Does somebody has an idea how to do this? 

 

1 REPLY 1
lbendlin
Super User
Super User

You cannot measure a measure.  Implement your entire business logic in a single measure.

Helpful resources

Announcements
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!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

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.