how to add a summary value in row of matrix

[Anonymous]

Hi, here is the data

I swithed the rows into values in matrix:

but the visual should be like this, a summary of top 3 months should be added

so how to add such a summary value in rows? Thank you.

[v-xiaotang]

Hi @Anonymous 

Thanks for reaching out to us.

I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[visheshjain]

Hi @Anonymous,

Not sure I understood the question properly, but have you tried turning on row and column subtotals on the matrix?

Thank you,

Vishesh Jain

[Anonymous]

Thanks, it's a summary of a certain values rather the total of all values

[visheshjain]

Hi @Anonymous,

Please have a look at the following video, this should answer your question.

Computing totals by summing visible values in DAX - YouTube

You can use the same concept and change the measure only for the total line.

Thank you,

Vishesh Jain