Divide all rows by a single row

[JonathanK1999]

Hi! I want to divide all rows by a single calculated row.

Ex: I want to divide each single category (cleaning, laundy, supplies, material, soap, salaries, etc.), by the total sales to understand what percentage each row reporesents of total sales. I know how to do it individually by just dividing and filtering by each row, but how can I do it with the total for it to be a calculated column rather than just a calculation?

Sales
Cleaning	$    10,000.00
Laundry	$           10.00
Supplies	$         100.00
Costs
Material	$           40.00
Soap	$         400.00
Salaries	$      4,000.00
Machines	$           30.00
Other Costos
Rent	$         500.00

[andhiii079845]

Show your underlaying data. Your desired result in a example (a table). This helps the different user here to help you.

[andhiii079845]

Same question some hours before. Use please the search 🙂
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Row-divided-by-Total/m-p/3114865#M110255

[JonathanK1999]

Not really, I am looking to divide total sales, not total profit