Compare percentages

[harrinho]

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

[v-danhe-msft]

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]

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 %