Switch Formula error using dis connect tables

[Anonymous]

Hi Experts

Getting a switch formula error Consider using Value or Format cannot campair string and integer types...

ProductComplaints = SWITCH(
       "Downward" ,IF(SELECTEDVALUE(_TrendDirection[Direction]) = "Downward Trending", [Downward]),
       "Upward" ,IF(SELECTEDVALUE(_TrendDirection[Direction]) = "Upward Trending", [Upward]),
       "NoChange", IF(SELECTEDVALUE(_TrendDirection[Direction]) = "No Trend", [NoChange]),
       "NoTrend", IF(SELECTEDVALUE(_TrendTable[Trends]) = "No Trend", [NoTrend]),
       "SignTrend", IF(SELECTEDVALUE(_TrendTable[Trends]) = "Significant Trend", [SignificantTrend]), 
    [PMSComplaintsMN])

cannot see where i have gone wrong. i have two disconnect table and i am tryng to create one overall Switch formula..

[AlB · Accepted solution]

You're missing the very first argument on the SWITCH, the expression to be evaluated

[Anonymous]

HI AIB,

firstly apologies in reaching out to you directly, i was given your details as someone who is a DAX GURU and might be able to shed some light on a questioin that no can seem to answer... 

https://community.powerbi.com/t5/Desktop/Relationship-issue-with-Measure/m-p/788266#M379643

I have a relationship issue with a measure and i cannot filter the bar graph on the link within the question and cannot see the wood for the tree on how to resolve this issue.

[Anonymous]

thanks AIB, i am half a sleep. much appreicated.