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.

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

       

       

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