cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## 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 Quantities Sold

but I dont know how to write it as a measure. I need your help

1 ACCEPTED SOLUTION
Super User

Hi,

To your visual, drag the product name column from the Data Table and write these measures

Qty sold = sum(Data[Quantity])

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
3 REPLIES 3
Community Support

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Super User

Hi,

To your visual, drag the product name column from the Data Table and write these measures

Qty sold = sum(Data[Quantity])

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

@Aha2022 , The measure should be

Unit Sales by Product (%) = Divide(Sum(Table[Product Quantity Sold]), Sum(Table[total Quantities Sold]))

Assume above are columns

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.