Forum Discussion

Till's avatar
Till
Resolver II
5 years ago
Solved

Include slicer value in Measure

Hi All,

Transferring a value from a slicer into a measure is no problem with selectedvalue.
I have a table for the values:

 Measure:

f_empl_selected_value_aht := SELECTEDVALUE(
Tabelle[Value]
)
It works fine:

if i now change the filter from a dropdown to a controller it no longer works:

 

I think I have read that selected value does not work here.

Does anyone have a tip?

Thanks
Till
 
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Selectedvalue() will return only 1 value.  use MIN() or MAX() function instead.

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Till- Are you trying to select all values in that range? 

    For Eg: between 365 and 495? SELECTEDVALUE will not work in this case as it returns one result only? 

    Try making the column as WholeNumber and Change Summarization to Sum.

     

    Hope this Helps.

     

    Cheers,

    -Namish B

  • Till's avatar
    Till
    5 years ago

    Hi Namish,
    I always need only one value. I think the approach with Max or min is the right way. Unfortunately I do not know how to calculate the measure

    KR

    Till

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Till ,

     

    In than case, you dont need SELECTEDVALUE() Function

    Just use Min(ColumnName) or Max(ColumnName).

     

    Hope that works

     

    Thanks,

    Namish B

7 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    Hi,

    Selectedvalue() will return only 1 value.  use MIN() or MAX() function instead.

    • Till's avatar
      Till
      Resolver II
      5 years ago

      Hi,

       

      Thanks for your answer,
      at the moment I'm a little bit out of place. can you send me a measure example ?

      Kind Regards
      Till

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Till- Are you trying to select all values in that range? 

    For Eg: between 365 and 495? SELECTEDVALUE will not work in this case as it returns one result only? 

    Try making the column as WholeNumber and Change Summarization to Sum.

     

    Hope this Helps.

     

    Cheers,

    -Namish B

    • Till's avatar
      Till
      Resolver II
      5 years ago

      Hi Namish,
      I always need only one value. I think the approach with Max or min is the right way. Unfortunately I do not know how to calculate the measure

      KR

      Till

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Till ,

         

        In than case, you dont need SELECTEDVALUE() Function

        Just use Min(ColumnName) or Max(ColumnName).

         

        Hope that works

         

        Thanks,

        Namish B