Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

capture slicer selection

Need a dax to capture second higher slicer selection. In my case it is 100:

 

I know I can get selected value when single selection with:

SELECTEDVALUE('price table'[price max])

 

But how to get this with multiple ones?

I am gonna use it later to create sales measure to work on ranges selected on slicer

Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous,

     

    Change it as follows.

    Measure =
MAXX (
    FILTER (
        ALLSELECTED ( 'price table'[price max] ),
        'price table'[price max] < MAX ( 'price table'[price max] )
    ),
    'price table'[price max]
)
    + 0

4 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    7 years ago

    Anonymous,

     

    You may use measure below.

    Measure =
MINX (
    TOPN ( 2, VALUES ( 'price table'[price max] ), 'price table'[price max], DESC ),
    'price table'[price max]
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks Sam,

       

      I think I was not precise in my question. Your measure is working but not in all cases, which I had not mentioned before.

      It works on total only.

      Sorry for this. I hope you can help further.

      How to do a measure to work in a matrix like this?:

       

      An output should show the figures like those on red.

       

      • v-chuncz-msft's avatar
        v-chuncz-msft
        Community Support
        7 years ago

        Anonymous,

         

        Change it as follows.

        Measure =
MAXX (
    FILTER (
        ALLSELECTED ( 'price table'[price max] ),
        'price table'[price max] < MAX ( 'price table'[price max] )
    ),
    'price table'[price max]
)
    + 0