Drill Trough measure Row subtotals total value

[Anonymous]

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


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


Table Row Subtotal in Page 1 matrix table - should be


Another Example:

Page 1

Page 2


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

Any ideas are appreciated.

[v-rzhou-msft]

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

[v-rzhou-msft · Accepted solution]

Hi @Anonymous 

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.

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)

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.