Matrix Multiple Aggregation in Grand Totals

[Anonymous]

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?

[v-juanli-msft]

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]

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!