Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

SWITCH(TRUE() Divide Function returning error : "Switch Function does not support comparing values"

Hi Guys, I have a custom table created using the Switch true function. After adding a divide expression to my 3rd switch function it returns an error. Does anyone know why? Thank you...

Need Help

v-xiaotang

4 years ago

Hi Anonymous

Try this measure,

Planned Metric =
VAR _a =
    SELECTEDVALUE ( 'Planned Accounts Table'[Description] )
RETURN
    IF (
        _a = "FY22Q4 Total Planned Accounts CAP",
        FORMAT ( [Count of Accounts], "0,00" ),
        IF (
            _a = "Quote Tap",
            [AP_Automation_CountofQuotes],
            IF ( _a = "Quote Tap Rate %", [Quote Tap Rate] )
        )
    )

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Anonymous

Not applicable

4 years ago

Hi Vahid

Im getting this error. I'm very sure all the formatting is changed to whole number format . However, the error is still showing. Is this because the first two switch functions are numerical wheareas the last switch function is in %.