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

Drill Trough measure Row subtotals total value

Hello,

I decied to make a "hefty" report however not all infromation can be shown in the matrix table due to visible information limitations on the screen, therefore some information has been put to another page with the remainder of values that did not fit in the previous page.

The issue now that I can't overcome is showing the Rows sub total value as total as some filetered values are on another matrix table in another page.


How to show the cummulative total value of the row in the primary table that has been filtered to accomodate, the second table value just in case i can hide with the white line. There are other regions e.g. Europe IT however it fits fine.
20,811,931 + 30,615,179 = 51,427,110
Table 1 in Page 1
IT 1.png

Table 2 in Page 2 - with left over values that not fit in page 1
IT 2.png

Table Row Subtotal in Page 1 matrix table - should be
IT 3.png

Another Example:

Page 1
OBL 1.png
Page 2
OBL 2.png

Page1 Subrow total:
54,989,306 + 26,896,931 = 81,886,237

Any ideas are appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Hi @iHickUp 

I think you want to show Total without being filtered by filter.

Due to I don't know your data model, I build a sample to have a test.

1.png

You can use IF and ISINSCOPE function to build a measure.

Measure = IF(ISINSCOPE('Table'[LEVEL3]),SUM('Table'[Value]),SUMX(ALL('Table'),'Table'[Value]))

Result is as below.(I select ID =1 in Filter Field)

2.png

If this reply still couldn't help you solve your problem, please show me more details about your table/data model.

And please show me a screenshot of the result you want. Or you can share your pbix file with me by your Onedrive for Business.

You can download the pbix file from this link: Drill Trough measure Row subtotals total value

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

 

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Hi @iHickUp 

I think you want to show Total without being filtered by filter.

Due to I don't know your data model, I build a sample to have a test.

1.png

You can use IF and ISINSCOPE function to build a measure.

Measure = IF(ISINSCOPE('Table'[LEVEL3]),SUM('Table'[Value]),SUMX(ALL('Table'),'Table'[Value]))

Result is as below.(I select ID =1 in Filter Field)

2.png

If this reply still couldn't help you solve your problem, please show me more details about your table/data model.

And please show me a screenshot of the result you want. Or you can share your pbix file with me by your Onedrive for Business.

You can download the pbix file from this link: Drill Trough measure Row subtotals total value

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

 

View solution in original post

Highlighted
Community Support
Community Support

Hi

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

 

Best Regards,

Rico Zhou

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors