Forum Discussion
Custom Total
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
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/
2 Replies
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/
amitchandak
Thanks your guidance has guided me to find the way to do the calculations.
Thank you!
