How to subtract a column from a measure with a filter

[kzagorsky]

I have a "Payments" table, which lists the payments received by a student for a specific course, each student may have several payments for a course. In another table "courses", I have the course price.

I've created a measure which summarizes the amount paid per student:

SumPaid = SUMX(VALUES(FACT_Payments[StudentId]),CALCULATE(SUM(FACT_Payments[Amount_paid])))

I need to create a measure which calculates the remaining amount to be paid. "SumPaid" - "CoursePrice" and I need this to be per student.

Thanks a lot!

[prateekraina · Accepted solution]

Hi @kzagorsky,

Refer to this pbix for your answer. Let me know if you face any issues.

Prateek Raina

[kzagorsky]

This was very helpful. Thank you very much!!!

[prateekraina]

Hi @kzagorsky,

Glad to know that it solved your problem. Kindly hit the thumbs up button for my answer.

Prateek Raina