Forum Discussion
Solved
Unit sales by product formula
Hello I have a table shows the products name and I want to know what is the product percentage from all the quantity sold. the formula is Unit Sales by Product (%) = Product Quantity Sold/ total Qu...
Hi,
To your visual, drag the product name column from the Data Table and write these measures
Qty sold = sum(Data[Quantity])
Qty sold across all products = calculate([Qty sold],all(Data[Product name]))
Qty sold (%) = divide([Qty sold],[Qty sold across all products])
Hope this helps.
Ashish_Mathur
Super User
Super UserHi,
To your visual, drag the product name column from the Data Table and write these measures
Qty sold = sum(Data[Quantity])
Qty sold across all products = calculate([Qty sold],all(Data[Product name]))
Qty sold (%) = divide([Qty sold],[Qty sold across all products])
Hope this helps.