topic Re: Multiple selectedValues DAX in DAX Commands and Tips

Multiple selectedValues DAX

rajukarkee — Fri, 22 Nov 2019 21:58:51 GMT

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,

)

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.

Re: Multiple selectedValues DAX

Anonymous — Fri, 22 Nov 2019 22:10:41 GMT

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