Forum Discussion
Dynamic total column matrix
Hi Fellow Bi users, I am facing an issue with matrix visual where i need to column totals. I tried out many measures and googled around for a solution but none seem to work dynamically. Below is ...
Anonymous
Anonymous see solution attached, look at table DQ, ignore other tables.
basically, you unpivot the data in power query, and then from there everything is super simple.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) 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.⚡