topic Re: How I can create new lines that sumarize others lines and shows in my report as lines in Report Server

How I can create new lines that sumarize others lines and shows in my report as lines

Marco_Antonio — Fri, 20 May 2022 14:59:21 GMT

I've created a dashboar as the next image show it, and I need to create new lines that show the result Sales - SVC and after that Its show into report but as lines bellow these lines as result.

I looked for differents website but all show how created new measure or calculate information, but I didn't the right answer to my problem.
Thanks in advance.

Re: How I can create new lines that sumarize others lines and shows in my report as lines

d_gosbell — Sat, 21 May 2022 02:38:24 GMT

You could maybe look at an approach like this one https://www.sqlbi.com/blog/alberto/2011/03/01/powerpivot-parent-child-and-unary-operators/ to make the grand total level show the value for Sales - Svc

Re: How I can create new lines that sumarize others lines and shows in my report as lines

v-luwang-msft — Tue, 24 May 2022 07:07:42 GMT

Hi Marco_Antonio ，

Pls test the below dax to create a new column:

Table 2 = UNION ( SUMMARIZE ( 'Table', 'Table'[Quarter], 'Table'[Month], "Type1", "SALE-Svc", "Type2", " ", "value", CALCULATE ( SUM ( 'Table'[value] ), FILTER ( ALL ( 'Table' ), 'Table'[Quarter] = MAX ( 'Table'[Quarter] ) && 'Table'[Month] = MAX ( 'Table'[Month] ) && 'Table'[Type1] = "Sales" ) ) - CALCULATE ( SUM ( 'Table'[value] ), FILTER ( ALL ( 'Table' ), 'Table'[Quarter] = MAX ( 'Table'[Quarter] ) && 'Table'[Month] = MAX ( 'Table'[Month] ) && 'Table'[Type1] = "Svc" ) ) ), 'Table' )

before:

after:

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

Re: How I can create new lines that sumarize others lines and shows in my report as lines

Marco_Antonio — Thu, 26 May 2022 12:18:21 GMT

Thanks, I am trying to aplied your answer but I cannot do yet I am with a lot of work right now and this question it for a new proyect and proposal to my bosses.

But sound logic and good, thanks for your time.