Include slicer value in Measure

[Till]

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

[Ashish_Mathur · Accepted solution]

Hi,

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

[NamishB · Accepted solution]

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 · Accepted solution]

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

[NamishB · Accepted solution]

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 · Accepted solution]

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

[Till]

Hi,

it`s works.

Thanks and be healthy

[NamishB · Accepted solution]

Hi @Till ,

In than case, you dont need SELECTEDVALUE() Function

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

Hope that works

Thanks,

Namish B

[Till]

Hi,

It should always return the value selected in the slicer. As said, in a dropdown no problem.

(Measure with min)

In this example 408
KR

Till

[Ashish_Mathur · Accepted solution]

Hi,

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

[Till]

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