Editing the Row Subtotal Aggregate Calculation on Matrix Table

[diegoleonm]

I have a matrix table were I get the top five accounts for a quarter using the rank system built in PBI, the issue I'm having is that the [revenue_share] row subtotal is giving me the average of the percentages of the top five accounts, when what I need is the sum of the percentages (which would be the value under [Top 5 rev share] column. Is there a way to get the sum of precentages in the row subtotal instead of the averages?

[diegoleonm]

I have another question @amitchandak .

How can I sort first by year-quarter, and then by recognized revenue?

Basically what I need is for the order of Y-Q to be ascending and the recognized revenue to be descending once the matrix is expanded.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[amitchandak]

@diegoleonm , You need a measure like

Sumx(Values(Table[Rank]), [Revenue Share])

[diegoleonm · Accepted solution]

This worked! The only change that I did was this:

rev_share_adj = Sumx(Values(Table[revenue_share]), Table[revenue_share])