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

[Anonymous]

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

[v-xiaotang]

Hi @Anonymous 

Have you solved this question? If you have solved the question, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.❤️

If you need more help, please let me know.

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 · Accepted solution]

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.

[VahidDM]

HI @Anonymous 

You don't need to write the Switch and True for each line.

https://docs.microsoft.com/en-us/dax/switch-function-dax

Can you copy and paste your formula here, then I will correct that.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[Anonymous]

Planned Metric = 

SWITCH(TRUE(),SELECTEDVALUE('Planned Accounts Table'[Description])="FY22Q4 Total Planned Accounts CAP",FORMAT([Count of Accounts],"0,00"), 
SWITCH(TRUE(),SELECTEDVALUE('Planned Accounts Table'[Description])="Quote Tap",[AP_Automation_CountofQuotes]))
//SWITCH(TRUE(),SELECTEDVALUE('Planned Accounts Table'[Description])="Quote Tap Rate %",[Quote Tap Rate]))

here you go

[VahidDM]

@Anonymous 

Try this:

Planned Metric =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( 'Planned Accounts Table'[Description] ) = "FY22Q4 Total Planned Accounts CAP", FORMAT ( [Count of Accounts], "0,00" ),
    SELECTEDVALUE ( 'Planned Accounts Table'[Description] ) = "Quote Tap", [AP_Automation_CountofQuotes]
)
    / SWITCH (
        TRUE (),
        SELECTEDVALUE ( 'Planned Accounts Table'[Description] ) = "Quote Tap Rate %", [Quote Tap Rate]
    )

But it seems there is an issue with the logic of your formula, all of those conditions are based on the selectedvalue on a same column!!

if that does not work, please share a sample of your data and the expected result, maybe there is another way to find the solution.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[Anonymous]

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

[VahidDM]

@Anonymous 

please share a sample of your data and the expected result in a text format

Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/