Forum Discussion

rajukarkee's avatar
rajukarkee
Regular Visitor
6 years ago
Solved

Multiple selectedValues DAX

Test Site Threshold = VAR ProgramSelected =     SELECTEDVALUE ( 'Master BTPP Report'[Program] ) VAR YearSelected =     SELECTEDVALUE ( 'Master BTPP Report'[Application Received Date].[Year] ) ...
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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