cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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

1 ACCEPTED SOLUTION
Super User

@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 2
Super User

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

Frequent Visitor

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors