Forum Discussion
Lookup with Measure
Hi gill_thornton,
I have made a simple model with only the grades table and a metric with a value input, no other tables or relationships.
How are you calculating the metric? is there any relationship between the grades and the table from where you are calculating the metric?
Hi gill_thornton,
Taking into account that you have the table above for your grade you need to do something similar to this:
Grade Value =
MINX (
FILTER (
'Grade Table',
'Grade Table'[APS Band Min] <= [A level APS]
&& 'Grade Table'[APS Band Max] >= [A level APS]
),
'Grade Table'[Grade]
)
Thank you for this solution. It looks as though it should work perfectly, but when I apply, it is returning a grade A, which is incorrect. I'm not quite sure where I'm going wrong.
Hi gill_thornton,
I have made a simple model with only the grades table and a metric with a value input, no other tables or relationships.
How are you calculating the metric? is there any relationship between the grades and the table from where you are calculating the metric?
Thank you - it is always relationships!! I should learn to check and delete any auto-detected on a new table. Appreciate your help.
