Forum Discussion
gill_thornton
Helper I
Helper ILookup 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...
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?
Greg_Deckler
Community Champion
Community Championgill_thornton Not sure if I understand completely but maybe something like a SWITCH(TRUE(), ...) statement like:
Measure =
SWITCH(TRUE(),
[Current Measure] > 45, "A",
[Current Measure] > 35, "B",
[Current Measure] > 25, "C",
[Current Measure] > 15, "D",
"F"
)