Forum Discussion
Minimum across column
Hi all, I have a table in visualization as below: Customer Sales Quantity Avg Sales Discount Net Sales Sales cat Quantity cat Net Sales cat Customer category A 4000 20 200 ...
Anonymous
Try this
Customer Category = MIN ( MIN ( SELECTEDVALUE ( [Quantity Cat] ), SELECTEDVALUE ( [Sales Cat] ) ), [Net Sales Cat] )
Anonymous
Are " sales cat, quantity cat and net sales cat" measures or calculated columns?
MIN allows only 2 arguments..so you can wrap a MIN function inside another MIN
Customer Category = MIN(MIN([Quantity Cat],[Sales Cat]),[Net Sales Cat])
See the attached sample file
Zubair_Muhammad, sales cat and quantity cat are new column while net sales cat is new measure.
Anonymous
Try this
Customer Category = MIN ( MIN ( SELECTEDVALUE ( [Quantity Cat] ), SELECTEDVALUE ( [Sales Cat] ) ), [Net Sales Cat] )Got it, Thanks