Minimum across column

[Anonymous]

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.

[Zubair_Muhammad]

@Anonymous

What if you use Min Function as Measure

Customer Category =
MIN ( [Quantity Cat], [Sales Cat] )

[Anonymous]

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.

[Zubair_Muhammad]

@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

[Anonymous]

@Zubair_Muhammad,

I can't do that because sales cat, quantity cat and net sales cat are from different table.

[Anonymous]

@Zubair_Muhammad, sales cat and quantity cat are new column while net sales cat is new measure.

[Zubair_Muhammad · Accepted solution]

@Anonymous

Try this

Customer Category =
MIN (
    MIN ( SELECTEDVALUE ( [Quantity Cat] ), SELECTEDVALUE ( [Sales Cat] ) ),
    [Net Sales Cat]
)

[Anonymous]

@Zubair_Muhammad

Got it, Thanks