Total for a table both vertical and Horixontal

[Anonymous]

Hi,

I need to total of a table both vertival and Horizontal.

Yellow highleted in the required result.

Thanks in Advance !!

[parry2k]

@Anonymous not sure I understood your reply. Your raw data is pivoted or unpivoted? Can you share that information?

[Anonymous]

@parry2k 

My data is Pivoted.

[parry2k · Accepted solution]

@Anonymous that's what I thought, you need to unpivot your table as a best practice which you can do it Power Query.

To do so, follow these steps:

- transform data
- select product table
- right-click, unpivot other columns it will add two columns, attribute, and value, rename these as per your requirement
- close and apply

To visualize,
- matrix visual:
- add product rows,
- add attribute on columns
- add value on values section

and that's it. It will get you row and columns total.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[amitchandak]

@Anonymous , you can have this in matrix if "High", Medium and low are column values. If they are column they you can create a total column and use in table

total = [high]+[medium]+[low]

[parry2k]

@Anonymous the scalable solution depends on how your raw data looks like, if it is pivoted, I would recommend to unpivot it, and then everything will work automatically in matrix visual.

So if you can share sample data, it will help to provide an appropriate solution.

[Anonymous]

@parry2k ,

Yes I have used Pivot colum to the values.