Forum Discussion

Aha2022's avatar
Aha2022
Regular Visitor
3 years ago
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...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Aha2022 ,

 

measure = 
var Product Quantity Sold = calculate(sum(sales),allexcept(table,[product]))

var total Quantities Sold = calculate(sum(sales),all(table))

return
Product Quantity Sold/Quantities Sold

 

Best Regards,

Jay