sum of the rows total in matrix table

[Anonymous]

I have the data in matrix table it contains the each month of the data of particular variables, like below

  TYPE    jan  feb  march  april   

    a         1    2    3           5

    b         1    2    3           8

    c          5    2    3          10

how can i display the total of each row like,

TYPE    jan  feb  march  april   total

    a         1    2    3           5       11

    b         1    2    3           8       14

    c          5    2    3          10       20

I tried using measure, but no luck

Thanks

[v-kelly-msft · Accepted solution]

Hi @Anonymous ，

1.Go to query editor>select column jan,feb,march,april >unpivot columns:

2.Put "type" in Rows,"Attribute" in Columns,"value" in values:

And you will see:

For the related .pbix file,pls click here.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Anonymous ,

Better you unpivot the data

https://radacad.com/pivot-and-unpivot-with-power-bi

And then use it matrix visual