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] )
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