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 | 15 | 3985 | 0 | 1 | 0 | 0 |
| B | 3000 | 5 | 600 | 10 | 2990 | 1 | 3 | 1 | 1 |
| C | 1000 | 25 | 40 | 5 | 995 | 2 | 0 | 2 | 0 |
| D | 500 | 10 | 50 | 1 | 499 | 3 | 2 | 3 | 2 |
*Net Sales = Sales - Discount (Discount is from other table)
Sales cat, Quantity cat and Net Sales cat are based from Sales, Quantity and Net Sales value.
What I want is to get the Customer category. Customer category is based on the minimum among Sales cat, Quantity cat and Net Sales cat.
Anonymous
Try this
Customer Category = MIN ( MIN ( SELECTEDVALUE ( [Quantity Cat] ), SELECTEDVALUE ( [Sales Cat] ) ), [Net Sales Cat] )
7 Replies
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