Forum Discussion
Summarising tables without aggregation
Hello Experts I am trying to summarise a student assessment table without aggregating the scores. I want to compare the difference (improved/declined) in another column but first of all I have a...
Hi, Elisa112
Based on your information, I create sample table:
Then create measures:
First Assessment Meeting =
CALCULATE(
MIN('Table'[Assessment Value (IS Score)]),
'Table'[Assessment Type] = "Beginner" &&
'Table'[Assessment Stage] = "First Assessment Meeting"
)First Assessment Review =
CALCULATE(
MIN('Table'[Assessment Value (IS Score)]),
'Table'[Assessment Type] = "Beginner" &&
'Table'[Assessment Stage] = "First Review Meeting"
)Difference +/- =
[First Assessment Review] - [First Assessment Meeting]
Put this measure in table view:
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, but I need to create a summary table before i create the measures and this is what I have an issue with
any ideas?
thank you