Subtotal in PowerPivot table

Anything related to PowerPivot and DAX Formuale
lucausa75
Posts: 1
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


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 1 guest