How to divide lines by Total

[JMS1985]

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

[amitchandak · Accepted solution]

@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]

Hello @amitchandak I have used your proposed formula and it has worked. Thank you for your fast reply and have a nice weekend!