Forum Discussion

ironryan77's avatar
ironryan77
Icon for Kudo Commander rankKudo Commander
9 years ago
Solved

Multiple subtotals in one matrix?

How do I create multiple subtotals in one matrix?  e.g.

date_str               A                      B                      C
201601               A1                    B1                    C1
201602               A2                    B2                    C2
201603               A3                    B3                    C3
201604               A4                    B4                    C4
Avg               Avg(A)              Avg(B)             Avg(C)
Total             Sum(A)            Sum(B)            Sum(C)
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    Hi ironryan77,

     

    Currently, there is no such a function to achieve this requirement. Currently, a table can only has one aggregation row.

     

    If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.https://ideas.powerbi.com/forums/265200-power-bi-ideas

     

    Regards,
    Charlie Liao

1 Reply

  • v-caliao-msft's avatar
    v-caliao-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi ironryan77,

     

    Currently, there is no such a function to achieve this requirement. Currently, a table can only has one aggregation row.

     

    If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.https://ideas.powerbi.com/forums/265200-power-bi-ideas

     

    Regards,
    Charlie Liao