Multiple selectedValues DAX

[rajukarkee]

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

You could try the following:

Test Site Threshold =
VAR ProgramSelected =
    SELECTEDVALUE ( 'Master BTPP Report'[Program] )
VAR YearSelected =
    SELECTEDVALUE ( 'Master BTPP Report'[Application Received Date].[Year] )
RETURN 
   IF ( YearSelected = 2019,
    SWITCH (
        ProgramSelected,
        "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 Consultant
www.designmind.com