i'm struggling with an average, i translate below a similar example:
Go to Solution.
This should work:
Weighted Sales =
FactSales[Sales] * FactSales[Duration] ),
SUM ( FactSales[Duration] )
it doesn't work unfortunately
it gives me same value for each Salesmen
Hmm. Looks like it works for me?!
after 2 hours i realised that i made a column instead of a measure...