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 ...
Need Help
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!