Please help me to find Average of Active Head count using Pivot Measures. Active Head Count := CALCULATE([JoinersCounts]-[leaversCounts],FILTER(ALLSELECTED('Date'[Date]),ISONORAFTER('Date'[Date],MAX('Date'[Date]),DESC))) Avg. of Active Head Count Please help me to find Avg. of Active Head Count for each month example given below. If possible please do calculation in attached excel only. ![82066-image.png][1] [1]: /answers/storage/attachments/82066-image.png
