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.

7 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

       

      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's avatar
        VahidDM
        Super User
        4 years ago

        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/

         

         

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

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    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.