I have to find products with less quantity.

[Anonymous]

I have one scenario. I have to find products with less quantity. Can you please suggest a solution.

[Uzi2019]

hi @Anonymous 

please find the solution using below link. most probably TOPN function will solve your problem.

https://docs.microsoft.com/en-us/dax/topn-function-dax

or else you can use top N option from filterpane(visual or page level filter) under fitertype(Basic, advance, TOPN) option.

Please hit like if it will solve your problem.

Thanks,

[amitchandak]

Not very clear. Can you give an example? In case you are looking for the top 10 based on something. You have an option in the filter pane

[Anonymous]

Hi,

Can you try the below

Table_Expression:= SUMMARIZECOLUMN(Table[Product Name], "Maximum Quantity", MAX(Table[Total_Quantity]))