Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

How to get second lowest value from below table

Hi Team,

Can you please help me on below  table to get second lowest value:

A as 2000 and B as 3000

I have tried below dax but getting lowest value and here there is no filter to be selected.

Test =
VAR _MinAll = MINX(all('Sales'),'Sales '[values]) RETURN CALCULATE(MINx('Sales ,'Sales '[values]),''Sales '[values]>_MinAll)

 

categoryvalue
A1000
A2000
A3000
B3000
B5000
B1000
Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    2 years ago

    Anonymous Try:

    Second Lowest Value Measure = 
  VAR __Min = MIN('Table'[Value])
  VAR __Table = FILTER('Table', [Value] > __Min)
  VAR __Result = MINX(__Table, [Value])
RETURN
  __Result
  • FreemanZ's avatar
    FreemanZ
    Super User
    2 years ago

    hi Anonymous 

     

    try to plot a table visual with category column and a measure like:

    Measure =
    VAR _max = 
    MAXX(
        data,
        data[value]
    )
    RETURN
    MAXX(
        FILTER(data, data[value]<_max),
        data[value]
    )