Divide one summarized column by another

[argnist]

Hi all,

does anyone know the way to divide one summarized column over to another summarized column?

When I try something like SUM (Total Sales) / SUM (Items Sold) it calculates it for each item (for Laptop 1, Laptop 2, etc.) instead of the for the group of items (Laptop and Phones)

Here is a Matrix visual I have in Power BI (the 3rd column, which I need to calculate is simply Total Sales/Items Sold)

Item Category	Total Sales	Items Sold	Average per item
Laptops	970,000	970	1000
Phones	500,000	625	800

This is how the original data set looks like:

Item	Total Sold	Items Sold
Laptop 1	700	12
Laptop 2	800	10
Laptop 3	1000	14
Laptop 4	950	10
…	…	…
Phone 1	700	24
Phone 2	750	65
Phone 3	800	17
…	…	…

My question might be confusing - but please let me know if I can explain more.

[argnist · Accepted solution]

It is solved now.

But in case anyone is interested in solution: I've used New Measure VS New Column, and as it is well put here the New Measure evaluates it when used on the visual (VS New Column which evaluates on each row in the table)