Forum Discussion
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 the days to know my value per day.
However I would like to divide the production of each product by the total days of each line, so the sum of each value per day is the same as the total value per day.
e.g. for the first line and product I want to divide: 12.4€/368 days
Thanks in advance for the help
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]))
2 Replies
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!
