Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Switch Formula error using dis connect tables

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..

Need Help
  • AlB's avatar
    AlB
    6 years ago

     

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

3 Replies

  • AlB's avatar
    AlB
    Community Champion
    6 years ago

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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.