Custom Total

[tarocha]

You could help me with the following scenario.

I have an array and make a custom subtotal for each row.

In the example, I need the headcount to be the average of the months, the admission is only the last month, and the turnover is the sum of the months.

Follow the link for the sample pbix.

Thank you very much

[amitchandak · Accepted solution]

@tarocha , Assuming these 1,2,3,4 are month no

Try new measures like

averageX(values(Table[Month no]), [Headcount])

calculate([admission], filter(allselected(Table), Table[Month no] = max(Table[Month no] )))

or you can is filtered and push this calculation to grand total

refer:https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[tarocha]

@amitchandak 
Thanks your guidance has guided me to find the way to do the calculations.
Thank you!