Switch DAX Formula Error

[Anonymous]

Hi Experts

Cannot see what i am doing wrong here with the switch function using a dis connected table....

DAX

NoTrend_Significants = 
VAR _Trendmove = SELECTEDVALUE(_TrendDirection[Trends])
Return

SWITCH(TRUE(),

    _Trendmove, "No Trend", [No Trend],
    _Trendmove, "Significant Trend", [Significant Trend],
[PMSComplaintsMN]
)

Error Message

[Ani1991 · Accepted solution]

Hi @Anonymous ,

You are trying to compare a Boolean object with a text value and hence the datatype mismatch error.

Can you try modifying the DAX expression as below,

NoTrend_Significants = 
SWITCH(SELECTEDVALUE(_TrendDirection[Trends]),
                "No Trend", [No Trend],
                "Significant Trend", [Significant Trend],
                [PMSComplaintsMN]
)

Hope this helps!!

Thanks,

Ani