Forum Discussion

diegoleonm's avatar
diegoleonm
Frequent Visitor
3 years ago
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 ...
  • diegoleonm's avatar
    diegoleonm
    3 years ago

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

    rev_share_adj = Sumx(Values(Table[revenue_share]), Table[revenue_share])
amitchandak's avatar
amitchandak
Super User
3 years ago

diegoleonm , You need a measure like

 

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

  • diegoleonm's avatar
    diegoleonm
    Frequent Visitor
    3 years ago

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

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