Summarising tables without aggregation

Hello Elisa112 , 

Using CALCULATE Instead of MINX:

1.CALCULATE is better suited for this case since it allows filtering the table directly.

2.Each CALCULATE block fetches the minimum score for specific assessment stages.

Assessment Summary =
ADDCOLUMNS(
SUMMARIZE(
vBIStudent_Assessment,
vBIStudent_Assessment[Student ID],
vBIStudent_Assessment[Assessment ID]),
"First Meeting Score",
CALCULATE(
MIN(vBIStudent_Assessment[Assessment Value (IS Score)]),
vBIStudent_Assessment[Assessment Stage] = "First Assessment Meeting",
vBIStudent_Assessment[Assessment Type] = "Beginner"),
"First Review Score",
CALCULATE(
MIN(vBIStudent_Assessment[Assessment Value (IS Score)]),
vBIStudent_Assessment[Assessment Stage] = "First Review Meeting",
vBIStudent_Assessment[Assessment Type] = "Beginner"),
"Difference",
[First Review Score] - [First Meeting Score])

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

Thank You

Dharmendar S

LinkedIN