Forum Discussion
undefined
So can you put Equipment N from Fixed Costs in a visual with a measure like:
Measure = SUM('Fixed Costs'[Fix Cost]) / [Equipment KMS]
?
Hey Greg_Deckler Thanks for replying.
No, I don't want to sum it
I want to use unique related values from a dimension table and use them in the expression ?
for eg:
the column [equipment] in my fact table is related to [equipment N] in dimension table.
Now what I want is to pull this fix cost from dimension table and use it in an expression, so that it goes to dimension table and give me the related value for every row iteration.
I am able to use it in a direct table visualization, but can't use it in a mathematical expression
I think what I am looking for is a "lookupvalue" or equivalent. But I am struggling to use it
Right going from the fact table back to your dimension would either require your relationship arrows to flow in reverse or in both directions or you would need LOOKUPVALUE or MAXX(FILTER(...),...).
Hard to be specific with LOOKUPVALUE and such, this may help you: https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434
It at least demonstrates the use of LOOKUPVALUE.
Otherwise, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.