So hopefully I can explain this so that it makes sense. My output below does not show the correct Tuition Revenue amount for the number of registrations.
The measure formula that I am using to get Tuition Revenue is as follows:
Tuition Revenue = SUM('WW Registrations'[Class Price])
My Model is below. I had to create a unique table because the WW MSSA Student Table had duplicates that were critical to keep but are necessary in breaking the students down appropriately.
How do I make it calculate the Tuition Revenue Correctly?
I have looked at the video https://www.youtube.com/watch?v=44QUjA5NDwY. But I think that is a little more advance than what I have. I dont have a quantity, I don’t have a price per thats already in the single column basically what the student was charged for that course.