Transpose table with weighted average

[AndrejZitnay]

Hello Guys,

Can you please help me with transposing table?

I need to create P&L per specific category.

My problem is that Category is in rows but I need that in columns.

Please be aware that current % are not averages but weighted average calculated as measures.

(DAX formula : SUMX('Test',Test'[Total amount]*Test[New ROA])/SUM('Test'[Total amount])

In best case scenario I would include there as well figures (these can be sums)

Many thanks in advance.

Andrej

[ImkeF]

Here you find a nifty workaround for your request: http://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/

... and of course: Pls vote for this to become a standard-feature here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10948962-matrix-measures-or-value...

[AndrejZitnay]

Hello ImkeF. Thank you for your sugestion. I will look at this once I will be back from my holiday.

[Baskar · Accepted solution]

Hi,

I tried but i can't any way to get table like which u mention in above.

but i suggested to u, y  u go with like this model. it will also help to u reach your goal.

pls look these images , and let me know if any help.

Select four column and click Unpivot

Now this is your Table

This is Matrix Report

[AndrejZitnay]

Hello Baskar. Thank you for your sugestion. I will look at this once I will be back from my holiday.