Multiple selectedValues DAX

Question

Test Site Threshold =

VAR ProgramSelected =

SELECTEDVALUE ( 'Master BTPP Report'[Program] )

VAR YearSelected =

SELECTEDVALUE ( 'Master BTPP Report'[Application Received Date].[Year] )

RETURN

SWITCH (

ProgramSelected,YearSelected,

"Charge Ready Bridge", 2019,5,

"T1",2019,6,

"T2", 2019,7,

"T3",2019,8,

"T4",2019 ,9,

"T4", 2019,10,

0

)

What I am trying to achieve is ,based on Program and year Selection ( 2 different slicers) by the user, i would like to assign value to measure "Test Site Threshold", please help.

anonymous · Accepted Answer

You could try the following:Test Site Threshold =VAR ProgramSelected =&nbsp;&nbsp;&nbsp; SELECTEDVALUE ( 'Master BTPP Report'[Program] )VAR YearSelected =&nbsp;&nbsp;&nbsp; SELECTEDVALUE ( 'Master BTPP Report'[Application Received Date].[Year] )RETURN&nbsp;&nbsp; &nbsp;IF (&nbsp;YearSelected = 2019,&nbsp;&nbsp;&nbsp; SWITCH (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ProgramSelected,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "Charge Ready Bridge",5,"T1",6,"T2",7,"T3",8,"T4",9,"T4",10,0 ),0)If I answer your question, please mark my post as a solution, this will also help others.Please give Kudos for support.Tomas Santandreu Polanco |Principal Business Intelligence Consultantwww.designmind.com

Forum Discussion

Multiple selectedValues DAX

1 Reply

Related content

display multiple elements with SELECTEDVALUE

DAX SWITCH + SELECTEDVALUE()

Display multiple values with selectedvalue

Add multiple selectedvalues

selectedvalue dax question