Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Matrix Multiple Aggregation in Grand Totals

Hi,

 

I have an scenario where 2 Values are used for summarizing data in Matrix across the Months in Columns. And finally i need to have the Multiple Aggregations in Totals (Like Sum of Sales, Max of Sales, Average of Sales etc.)

Please find the desired output (highlighted in yellow). 

Need help to acheive this?

 

 

Need Help

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi Anonymous 

    As tested, it can't be achieved directly in Power BI.

    Here is a workaround of a similar thread.

    With that method, the new created table would be static.

    If you'd like this solution and have difficult to implement for your scenario, please feel free to let me know.

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi,

       

      Thanks for the update.

      In this Idont need to set it up as Static Because, the user will select the Period Range like last 6 Months/3 Months/1 Year. So based on that Selection the No. of month Columns may Vary.

      I have tried to create separate measure for each aggregation and used it in the Values Field. 

      And then I tried to adjust the additional aggreagation column at Column Level (for each month).

      But this is working fine , but when the new month appars then this additional columns is appearing in the Matrix (for that month only)

      can we have the ability to adjust/hide the columns for particulr fields only?

       

      Thanks in advance!