Matrix Visual with calculated lines

[Thorsten_P]

Hello, I am an enthusiastic user of PowerBI. I have a challenge. I hope you can help me.

I have a table with this structure.

TABLE                  

Products             Value    Top

Product A            200         Top1

Product B            300         Top1

Product B            400         Top2

Product C            100         Top3

Produkt D           500         Top4

I would like to create a visual matrix. In the matrix I want to calculate more rows (like 'sum' in row 5).

VISUAL                                               

                                       Product A          Product B             Product C            Product D

Top1                                         200                   300                       

Top2                                                                  400                        

Top3                                                                                              100            

Top4                                                                                                                           500

sum(Top1,Top2)                       200                    700                        0                            0

sum(Top3,Top4)                           0                        0                   100                         500

sum(Top1,Top2)*1,05               210                    735                       0                             0

Is this possible?

[Thorsten_P]

Thank you very much. It works.

[lbendlin · Accepted solution]

Create measures for all of your "rows" , then put the measures into the values well and switch values to "Switch values to rows".

See attached