Add Measure at end of matrix not after each column

[ayaasfour]

Hey,

I have matrix and I create measure to calculate the sumn , I know that sum is ready made but I need other functions I just try it.

I need matrix to be like that

Date	col1	col2	My measure
2020-08-01	20	30	50
2020-08-02	10	20	30

But what happened to me that the measure repeted after each column by this way

Date	col1	My measure	col2	My measure	Total measure
2020-08-01	20	20	30	30	50
2020-08-02	10	10	20	20

so how to solve this problem please?

[mahoneypat]

I suspect you need to unpivot your data.  If Col1 and Col2 have values you plan to sum, you likely need to unpivot those two columns in the query editor.  You can then use the new Attribute column you'll get (with values of "Col1", "Col2") on columns in a matrix visual to get your desired result, including the total.

Unpivot columns (Power Query) - Excel (microsoft.com)

Pat

[Greg_Deckler · Accepted solution]

@ayaasfour One way is to turn off word wrap and shrink the unwanted columns. Otherwise, you can use a custom matrix hierarchy solution like the one here: https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

[ayaasfour]

whats is the benefit of turning of word wrap ? and How to shrink unwanted columns?

[Greg_Deckler]

@ayaasfour Word wrap prevents rows from getting bigger vertically when you shrink them. To shrink columns, hover your mouse over the right "line" in the column heading. Your cursor should change and then you click and drag the column to the left. If you don't turn off word wrap, as your column shrinks the letters/words will wrap and make the rows taller.