Subtotal in PowerPivot table

Anything related to PowerPivot and DAX Formuale
lucausa75
Posts: 2
Joined: Mon Oct 21, 2019 12:28 am

Subtotal in PowerPivot table

Postby lucausa75 » Mon Oct 21, 2019 1:02 am

Dear All,

I'm working on a PowerPivot and now I need to show only the main section Subtotal.
In the following image you see in yellow the total I need to show and in red the value I need to hide.
https://pasteboard.co/ICRnZy6.bmp

The values in column [b]Count of ID[/b] come from a measure...
Please, could you help me on finding the solution?

Thanks
Best Regards
Luca

datasquid
Posts: 2
Joined: Tue Oct 15, 2019 4:46 pm

Re: Subtotal in PowerPivot table

Postby datasquid » Tue Oct 29, 2019 5:55 pm

Hi

Can you not simply hide the rows that do need to be shown?

That is hide the rows in red

DataSquid

lucausa75
Posts: 2
Joined: Mon Oct 21, 2019 12:28 am

Re: Subtotal in PowerPivot table

Postby lucausa75 » Tue Apr 21, 2020 12:49 am

Dear all,

by this formula I almost get my result: =SUMX(DISTINCT(TABLE[QTY_SPLIT]),TABLE[QTY_SPLIT]) but obviously in my pivot instead to have a subtotal equal to 1425 I have (1425-38) because 38 is double in my values list.

https://i.postimg.cc/V6v2M8Kt/2020-04-2 ... ortana.png

How can I modify the formula in order to have the correct total in my pivot?

Thanks


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 2 guests