Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
Hi @argnist
Try the following:
1.- Click New Measure.
2.- Enter
Average Per Item = DIVIDE([Total Sales], [Items Sold])
3.- Put that new measure in the matrix
Hope That Helps
Vicente
Please try the DAX below.
Average per item = SUM(Table1[Total Sold])/SUM(Table1[Items Sold])
Regards,
Charlie Liao
Hi @argnist
Try the following:
1.- Click New Measure.
2.- Enter
Average Per Item = DIVIDE([Total Sales], [Items Sold])
3.- Put that new measure in the matrix
Hope That Helps
Vicente
Hi I have also faced the same issue but could not understand your solution but i think you have solved the problem which is similar like mine. Could you please hel me out to calculate to summarized columns. I have attached screenshot and pbix file for the same. THank you so much
Hi Kulchandra,
Try ....
Measure1 = DIVIDE(DIVIDE([Count Of Badges ID],[Duration Seconds]),60)
Hope That helps
Vicente
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |