Forum Discussion
Need help in creating measure
Hi you can create a matrix to achieve this.
rows = teacher & program
values = cost
as in your example you can disable subtotals like this:
Hello,
Many thanks Anonymous and Anonymous. Unforunetly it is not what I am looking for.
I am trying to create a measure not a visual that will count (or sum) the faculty cost for each student enrolled in a class. Let me know if what I say makes sense.
As an example, see below cost per student? I want to aggregate that. The real sum will be 100 Million+. But the below table is showing 13 million only because these amounts are defined in the course instructors table.
I guess a formula would = sum(count(student id) * cost per student). But this is not working.
Hi Hassanmoussa，
From the information you provided earlier, cost per student is a calculated column whose calculation formula is (salary / number of sections / number of students). Could you please provide which columns from which tables are involved? I'm not sure if there will be a context change when put the previous calculated column into new measure...
In addition, how do you calculate faculty cost in real life?Could you please provide your PBIX file if it is convenient?
Best Regards
Rena