Forum Discussion
Minimum across column
Anonymous
Try this
Customer Category = MIN ( MIN ( SELECTEDVALUE ( [Quantity Cat] ), SELECTEDVALUE ( [Sales Cat] ) ), [Net Sales Cat] )
Anonymous
What if you use Min Function as Measure
Customer Category = MIN ( [Quantity Cat], [Sales Cat] )
Sorry, Zubair_Muhammad I have left out one more element, which customer category is based on the minimum of sales cat, quantity cat and net sales cat.
I have tried the MIN in measure. But I have an error message 'A single value for column 'net sales cat' in table A cannot be determined.
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] )
I can't do that because sales cat, quantity cat and net sales cat are from different table.