subtotal matrix not shown

[Evandam]

hi,

i have a problem that calculated subtotals will not show in my matrix visual.

i am pretty sure it has something to do with te active relationship. I need this relationship in order to be able to slice on team and project.

but when this relationship is active my calculated subtotals (margin and net result) dont appear in the matrix visual.

Any good suggestions on how to fix this issue?

pbix example file 

[Evandam]

@aj1973  i like the 'out side of the box' approach! But unfortunalty not suitable in my case 😬
thanks for the effort!

[aj1973]

Hi @Evandam 

I did something tricky , hope it works for you

https://drive.google.com/file/d/1vI2oMKofBzBCQgxWHZ2Homp_YS70G-YS/view?usp=share_link