Matrix Table Customisation

[Boycie47]

Hi,

I am hoping someone can help.

I have a matrix table visual that displays sales data per location per month Year.

I have my Country, Region and Town as a hierarchy in my rows section of the matrix table.

Month Year in the column field and the Total Sales as the values.

I would like to add another metric called number of stores. This is calculated measure. I would like to only show it once in the table (before the first month year), but it replicates it for each month. Is there a way to remove this behaviour?

Thanks in advance 😊

[devesh_gupta]

@Boycie47 You can check out the following blogs. I hope it helps.

https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...

https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...