Simple percent calculation between two measures is not accurate

[helalm]

I have created two measures that show correct counts:

No. of available entries = 1834

No. of expected entries = 1846

I need to get a percentage of No. of available entries / No. of expected entries. Here is the formula I am using:

Percent = DIVIDE([No. of available entries],[No. of expected entries])

This results in %100.00 rather than 99.35. Can't figure out why? any thoughts?

Thank you

[helalm]

Hi there,

Thank you for the response. I am including sample pbix. I will be happy to provide further information.

QC First Batch Sample.pbix 

Thank you,

Helal

Helal

[v-zhangti · Accepted solution]

Hi, @helalm 

This is the result of the calculation in your file, please confirm.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

In your file both measures return 1832.  That is why you get 100%.

[v-zhangti]

Hi, @helalm 

I'm sorry I wasn't able to reproduce your question.

Please check if there are blank rows in the source data that affect the calculation result. Can you provide simple pbix files? Sensitive information can be removed in advance. 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.