Result of measure in every row

[deboec]

Hi all.

I managed to make a measure that shows me some kind of average - basically specific costs divided by the amount of people I can break those costs down to (e.g. recruiting costs of 50,000 divided by 20 total recruitments = average recruiting costs of 2,500).

My measure looks like that (German notation):

costs per recruitment:=

VAR Krek = CALCULATE([Kosten Rekrutierung]) (another measure that calculates the recruiting costs in total)
VAR Anzahlrek = CALCULATE(COUNT(dimRekrutierungen2021_einzeln[Kunde])) (sums up total recruitments)
RETURN
CALCULATE(DIVIDE(Krek;Anzahlrek;0);ALL(factKostenstellen_2021[Kostenstelle])) (gives me the average recruiting costs)

So far so good and pretty easy.

Now I have a table with different business units as rows and a column with recruitmens in those business units (if there acutally were some) and i want another column in my table that multiplies this number of recruitments by the result of my measure ("costs per recruitment").

What is the easiest and best way to do so? I can't just create another measure that multiplies the measures [# Recruitments]*[costs per recruitment] since the measure [costs per recruitment] gives me a blank column in my table only with the result in the bottom line.

Thanks in advance

[amitchandak]

@deboec , Based on what I got. You can not use a measure in new column.

You have to create a new measure.

Assume you ID at row level  in you table

new measure = suxm(values(Table[ID]), calculate(Sum(Table[Column]))*[Measure])

[deboec]

@amitchandak , thank you for your reply!

Unfortunately I am not quite sure, what you exactly mean by your chosen Table[ID], Table[Column] or which measure you mean by the [Measure] in your function.