Forum Discussion
undefined
Hi I am trying to define measure that gives "cost per kilometer" I have a fact table having [Equipment], [Loaded Distance] and [Deadhead Distance] column a dimention table called fixed Cost hav...
Hi Anonymous ,
Like this?
Measure =
DIVIDE(
SELECTEDVALUE('Fix cost'[Fix cost]),
[Equipment KMS],
BLANK()
)
Can you show the results you want in a table like mine? And indicate whether it is a measure or a calculated column.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.