Matrix repeats values

[haassiej]

Hi all,

I've a question about making a simple matrix. When I select two measures then these measures will repeat in the whole matrix. Normally I can use "turn off stepped layout" from the row headers. But this won't work right now.

What I want (made for the picture with 2 seperated matrix'):

The Invoiced Amount should be displayed one time, as in the picture. What I now have:

You can see that in my matrix the "Invoiced Amount" is display multiple times. What I want is that "Invoiced Amount" is displayed one time and the "Expenditure Categories" with the right Amount.

Hope you can help me 🙂

[v-chuncz-msft]

@haassiej,

You may try using SUMMARIZE Function to create a calculated table first.