cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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.

 

Capturar.JPG



Thank you very much

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Custom Total

@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/



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
Highlighted
Super User IV
Super User IV

Re: Custom Total

@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/



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Highlighted
Helper I
Helper I

Re: Custom Total

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

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors