Switch Function Help?

[Ahead4097]

I'm not sure if Switch is the right function I would need to use or not, but basically I'm looking to make it to where "Health 4 All" could change with a filter or a table selection. I'd like to be able to select a different option, and have it change inside my formulas. 

Is Switch the function I would want to use, or would this need to be a VAR function? 

Need help!

dax

[v-eachen-msft · Accepted solution]

Hi @Ahead4097 ,

I noticed that you have used some IF() functions, so you could replace it with SWITCH() function.

For example:

SWITCH(
       TRUE(),
       [Measure] = "YOUR CONDITION1",
       RESULT1 YOU NEED,
       [Measure] = "YOUR CONDITION2",
       RESULT2 YOU NEED
)

[edhans]

Can you provide a sample of data and show what your filters would look like and the expected result?

[Ahead4097]

I've attached some photos of the slicer, the data sample, and the end result. 

I have multiple measures that are using the Subject "Health 4 All" as a filter. I'm trying to get it to where I'll be able to slice the Subject, and "Health 4 All" will change in each of my measures to the selected Subject. 

Sorry for all the black...had to scrub. 

Measure examples:

Health4All Display Location =

IF([Health4All Type Built]="No Display","",

IF([Health4All Status] = "Display Unable to be Built", "",

CALCULATE(

LASTNONBLANK('View Responses'[Response Text],0),

FILTER('View Responses','View Responses'[Question] = "Where was the display built?"),

FILTER('View Responses', 'View Responses'[Subject] = "Health 4 All"),

FILTER('View Responses','View Responses'[Visit Date] = [Latest Visit Date User]))))

Health4All Status =

CALCULATE(

LASTNONBLANK('View Responses'[Option Text],0),

FILTER('View Responses', 'View Responses'[Subject] = "Health 4 All"),

FILTER('View Responses','View Responses'[Question] = "What is the status of promotional compliance?"),

FILTER('View Responses','View Responses'[Visit Date] = [Latest Visit Date User]))

Health4All Type Built =

IF([Health4All Status] = "Display Unable to be Built", "",

CALCULATE(

LASTNONBLANK('View Responses'[Response Text],0),

FILTER('View Responses','View Responses'[Question] = "What type of display was built?"),

FILTER('View Responses', 'View Responses'[Subject] = "Health 4 All"),

FILTER('View Responses','View Responses'[Visit Date] = [Latest Visit Date User])))

Health4All Unable Response =

IF([Health4All Status]= "I Built a Select Number of SKU's", "",

IF([Health4All Status] = "I Built Display on Previous Visit", "",

IF([Health4All Status] = "Display Built By Store", "",

CALCULATE(

LASTNONBLANK('View Responses'[Response Text],0),

FILTER('View Responses','View Responses'[Question] = "Why was the display unable to be successfully built?"),

FILTER('View Responses', 'View Responses'[Subject] = "Health 4 All"),

FILTER('View Responses','View Responses'[Visit Date] = [Latest Visit Date User])))))

End Result TableData SampleSlicer