Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |