Forum Discussion
Calculation derived from measure
when you add a new column in power bi, your formula only sees the current row by default, so you need to use a CALCULATE functin and a filter claus to open up your table so as you are looking at the current row, you can also see all the rows before.
unrortunately, this is not easy for a beginner to do, maybe this link can help you with understanding of how to see more than one row in the table as you add a new column:
Thank you andre, that gets me closer to what I need. I am now able to see the correct enrollment status per week. Now my next conundrum is how to then pivot on that FT/PT value. The client wants to see the number of students and the credit hours broken out by FT and PT.
This pivot should have 4 columns with count and total credits for FT and the same for PT.
If I try to add the FT/PT calculation to the pivot table columns, it won't let me. I can only add it as a Value.
Thank you andre! That did it!
no worries, glad it helped
You need to use this matrix
 
then place school in rows
ft/pt istatus in columns
and then your measures in values.
this should give you the 4 columns your looking for
Yes, but unfortunately, FT/PT is a calculation derived from the running total, and as such, cannot be used in columns. That is my conundrum. I need to be able to break out the headcount and credit hours into separate columns for FT and PT.
if your its in a calculated column it will work
if you send me a sample i can whip it together