Forum Discussion
Solved
How to divide lines by Total
Hello, Im having some trouble to get a value by the total of each line. I have 4 kind of products with a production in euros and the number of days of each product. I divide the production with th...
JMS1985 , One option is to drag this measure and right click on it in the visual pane. You should get option to show as % of row/column total
Another is to have a measure, Assume you have col1 on row and col2 on the column
Divide([measure], calculate([measure], removefilters(Table[Col2]))
JMS1985 , One option is to drag this measure and right click on it in the visual pane. You should get option to show as % of row/column total
Another is to have a measure, Assume you have col1 on row and col2 on the column
Divide([measure], calculate([measure], removefilters(Table[Col2]))
Hello amitchandak I have used your proposed formula and it has worked. Thank you for your fast reply and have a nice weekend!