Forum Discussion
Matrix column percentages
Hi everyone,
I have an issue on PBI or something that I would like to put which is unavailable.
This is data from a matrix that I created. Each pink/red row from the column one represent the total, this total is divided from the next rows below this. My issue is that I would like to put for the second column, for each row which should be 100%, be divided in percent below this one.
For example, the first 4 rows would be : 100 %
40,87 %
49,6 %
9,%
An other point, do you know how to put the grandtotals in the center of the column ?
Thank you very much !
1 Reply
- amitchandak
Super User
Anonymous , This is percent of subtotal
divide([Measure], calculate([Measure], removefilter(Table[Second Column])))
divide([Measure], calculate([Measure], allexcept(Table, Table[First Column]))
refer
Percent of SubTotal or Total: https://www.youtube.com/watch?v=6jTildcV2ho&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=37