Forum Discussion

Nick555's avatar
Nick555
Helper I
4 years ago
Solved

Using Switch With Calculated Variable

Greetings. I am trying to use a SWITCH statement to produce a result for a card. I want to base the result off of a percentage that is calculated. If the percentage is  >=.01 then I want the origina...
  • tackytechtom's avatar
    tackytechtom
    4 years ago

    Hi Nick555 ,

     

    To me it looks like a syntax issue. Can you try this?

    Measure = 
SWITCH (
    TRUE(),
    DIVIDE ( COUNT ( sheet1[review not completed] ), COUNT ( sheet1[review date] ) ) >= 0.01, DIVIDE ( COUNT ( sheet1[review not completed] ), COUNT ( sheet1[review date] ) ),
    DIVIDE ( COUNT ( sheet1[review not completed] ), COUNT ( sheet1[review date] ) ) < 0.01, "<.01",
    BLANK()
)


    If this does not work, feel free to share some sample data and I can have a deeper look into it 🙂

     

    /Tom
    https://www.tackytech.blog/
    https://www.instagram.com/tackytechtom/

tackytechtom's avatar
tackytechtom
Most Valuable Professional
4 years ago

Hi Nick555,

 

Hm, I can see why the measure is showing "< 0.01" cause that is how we coded it:

If your calculation returns a value equal or more than 0.01, then return that calculated value

If your calculation returns a value lowet than 0.01, then return "< 0.01"

ele return blank()

 

We covered all possible outcomes already in the first two if clauses, meaning we will never return blank(). Can you clarify in which cases we shall return blank()?


/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

Nick555's avatar
Nick555
Helper I
4 years ago

Apologies. You are correct that we covered the outcomes. Result of staring to long at this I'm afraid.

 

What I was thinking/wanting was that when the card above it (Revicew Not completed count) shows Blank, that this card show blank as well.

  • Nick555's avatar
    Nick555
    Helper I
    4 years ago

    Thanks you tomfox!!

     

    I was able to get it to work. After reviewing what you sent me, and a night of not looking at the issue, I took what you gave me and made a modification. Couldn't have done it without you!!!