Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rajukarkee
Regular Visitor

Multiple selectedValues DAX

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.
1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors