Forum Discussion
Solved
Editing the Row Subtotal Aggregate Calculation on Matrix Table
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 ...
This worked! The only change that I did was this:
rev_share_adj = Sumx(Values(Table[revenue_share]), Table[revenue_share])
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.