How to use a result of a measure in another measure

Anonymous — Thu, 18 Jan 2024 15:11:26 GMT

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:

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:

Does somebody has an idea how to do this?

Re: How to use a result of a measure in another measure

lbendlin — Fri, 19 Jan 2024 01:09:06 GMT

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

topic How to use a result of a measure in another measure in DAX Commands and Tips

How to use a result of a measure in another measure

Re: How to use a result of a measure in another measure