Forum Discussion

gill_thornton's avatar
gill_thornton
Icon for Helper I rankHelper I
3 years ago
Solved

Lookup with Measure

Hi I work in a school and am creating some headline measures for my post-16 cohort.  All grades have point values attached to them, e.g; A* = 60; A = 50 etc.  I have a calculated overall measure for...
Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    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?

MFelix's avatar
MFelix
Icon for Super User rankSuper User
3 years ago

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]
)

 

 

 

 

gill_thornton's avatar
gill_thornton
Icon for Helper I rankHelper I
3 years ago

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.