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
@aj1973 i like the 'out side of the box' approach! But unfortunalty not suitable in my case 😬thanks for the effort!
I did something tricky , hope it works for you
RegardsAmine JerbiIf I answered your question, please mark this thread as acceptedand you can follow me onMy Website, LinkedIn and Facebook
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.