The problem is that the Ending Headcount measure is a calculated measure and not a column value. Therefore I keep getting the following error message 1 "Measure 'Monthly Headcount'[12 Month AVG Headcount] : The AVERAGE function
only accepts a column reference as the argument number 1"
I don't really want to put the logic for Ending Headcount into the query above. Is there any way around this?
btw...I did try and do a SUM(Ending Headcount) / CountRows(......) and SUM only accepts a column reference as well....