Forum Discussion

harrinho's avatar
harrinho
Helper III
8 years ago

Compare percentages

Hi, 

 

I want to create a calculation which will flag 1 when the percentage is >=5% and 0 when the percentage is <5%. 

 

delta over 5 count = IF([Delta %]>=0.05,1,0)

However, it doesn't seem to work well, since as you can see below I get "1" in cases where the delta% is -100% for example

 

 

 

Need Help

2 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    8 years ago

    Hi harrinho,

    From your posted picture, I could not figure out your [Delta%] and [delta over 5 count] fields are calculated columns or measures? Could you offer me more information or could you please share pbix file if possible? If the report does contain sensitive data, please upload your report to your OneDrive and send the link to me via private message.

     

     

    Regards,

    Daniel He

    • harrinho's avatar
      harrinho
      Helper III
      8 years ago

      Thanks for the reply v-danhe-msft. The Delta % is a calculated measure which returns the delta between allocated and actual hours. 

       

      Delta % = DIVIDE([Delta Total],'CLARITY ALLOCATIONS'[Alloc Hours],0)

      The delta over 5 count is what I want to create. I want to get the count of people who have a >5% delta and I'm using the following calculation

       

      delta over 5 count = IF([Delta %]>=0.05,1,0)

      But it doesn't seem to work well as per screenshot in the initial post because I get "1" where delta is negative. I want to get "1" when the delta % is actually greater than 5 %