Analysing Assessment results

Hi Elisa112,

You can achieve it by creating below Measures:-

Calculate first assessment score:-

First Assessment Score =
CALCULATE(
MAX(AssessmentValue[AssessmentValue]),
Assessment[Assessment Stage] = "First Assessment"
)

Calculate review assesment score:-

Review Assessment Score =
CALCULATE(
MAX(AssessmentValue[AssessmentValue]),
Assessment[Assessment Stage] = "First Assessment Review"
)

Now create distance travelled:-

Distance Travelled =
[Review Assessment Score] - [First Assessment Score]

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!