Explicit "First" Measure

DAX DAX Calculations
1

Hi there
With a calculation group in my model I can no longer use implicit measures
The only place I would use them is to bring results into a matrix -
image

That is I bring in the “First” Result from the results table. In the context of the matrix each student only has a single result so this produces the visual that I want

Now I can’t bring in the result column - because it will not create an implicit measure. Is there an explicit measure that will bring in the first grade. I have tried firstnonblank but that does not seem to work - (I don’t understand what I would put as the “expression” in this context
no implicit measure.pbix (20.9 KB)

2

Hi,

Can you elaborate a bit more what you actually want to achieve it will help me to look for the solution .

Thanks,
Anurag

3

Hi,

If you want the below result only
image

Total need a logic as per your need .

You just need to use a measure like below:
MAx_Grade = Max(Grades[Grade])

Thanks,
Anurag
no implicit measure.pbix (21.2 KB)

4

Thank You Anurag!
I’m embarrassed at the simplicity - I had just assumed that MAX wouldn’t work on text so was diving down all sorts of rabbit holes with complex solutions that didn’t work.
Thank you again