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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
pjb120
Frequent Visitor

Using SWITCH or IF functions to determine which SELECTEDVALUE statement to use

I have situation depending on slicer selection to execute the correct  SelectedValue function.  For some reason I am pulling all records, not just the records being requested.

The formats I have tried are as follows

 

SWITCH( _case,
               1, SelectedValue(slicervalue))

IF ( _case = 1, SelectedValue(slicervalue))

 

I have researched and attemted many optons with none of them working.

 

What is happening and how can I make this work.

 

I appreciate your help.

 

pjb120 

 

1 ACCEPTED SOLUTION
olgad
Super User
Super User

Is it a measure you are creating(you cannot create a column) ? With the measure switch usually goes with min/max

switch(max(index),

1, SelectedValue())


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

View solution in original post

2 REPLIES 2
olgad
Super User
Super User

Is it a measure you are creating(you cannot create a column) ? With the measure switch usually goes with min/max

switch(max(index),

1, SelectedValue())


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime
pjb120
Frequent Visitor

Thanks for the quick reply.  I cannot use the MAX function as I am using the variable  _sterm.   I also tried with the If statement to no success.

 

Below is my measure, the objective is to substitute one of the following Fall, Spring, or Summer into the variable _iterm , it should only return the records for one off these terms.   If I make _iterm = SELECTEDVALUE(FallFilter[Term]) only he Fall records are returned.

 

Any advice you can offer is appreciated.,

 

-----------------------------------------------------------------------------------------------------------------------------------------------

 

EnrollmentCountX =

VAR _program = Enrollment[ProgramSelection]
VAR _termyear = Enrollment[TermYearSelection]
VAR _intdate =(Int(Right(Enrollment[AYYearSelection],4)))

VAR _sterm = Left(SELECTEDVALUE(Enrollment[Start Term and Year]) ,2)

VAR _iterm = If (_sterm = "Fa",  SELECTEDVALUE(FallFilter[Term]))
                   
VAR _enddate = SWITCH(_intdate,
                    2024, TODAY(),
                    2023, TODAY(),
                    2022,  EDATE(TODAY(), -12),
                    2021,  EDATE(TODAY(), -24),
                    2020,  EDATE(TODAY(), -36),
                    2019,  EDATE(TODAY(), -48)
                  )
 
VAR _count =    CALCULATE(COUNTROWS(Enrollment),
                All(Enrollment[Deposit Intent to Enroll Date/Time]),
                Enrollment[Program] = _program,
                Enrollment[Start Term and Year] = _termyear,
                Enrollment[Deposit Intent to Enroll] = "Yes",
                Enrollment[Deposit Intent to Enroll Date/Time] <= _enddate,
                FILTER('Enrollment',CONTAINSSTRING('Enrollment'[Start Term and Year], _iterm)))
RETURN
_count

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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