Forum Discussion

Anonymous's avatar
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's avatar
    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.

v-xiaotang's avatar
v-xiaotang
Community Support
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.