The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!
Solved! Go to Solution.
Hi @kzagorsky,
Refer to this pbix for your answer. Let me know if you face any issues.
Prateek Raina
Hi @kzagorsky,
Refer to this pbix for your answer. Let me know if you face any issues.
Prateek Raina
This was very helpful. Thank you very much!!!
Hi @kzagorsky,
Glad to know that it solved your problem. Kindly hit the thumbs up button for my answer.
Prateek Raina