Daily percentage computation is giving wrong result

[Ranga]

Hi,

I am trying to compute approved rate for the below sample data, my grand total approved rate may result to zero per line, I’m putting condition to keep blank() else I get NAN for %.
So I finally I get the below rate 5/12 = 4.16, but I getting wrongly as 3.16.

[MattAllington]

What is your formula?  I would try this

=divide(sum(table[approved count]),countrows(table))

from what I can see, there are only 11 records, meaning it should be 5/11

[Ranga]

Grand Total Count = Approved count + Rejected count, Which comes to 12 and SUM is not working.

[MattAllington]

What is the formula for "approved rate"?

[Ranga]

Approved Rate = Approved Count/Gran total. There's no option to send attachement, So i can send sample data and pbix. If u try with the data in the screen shot u can repro the same as well.

[MattAllington]

You will need to share the dax formulas if I am to try to help. Can you please cut and paste exactly what you have from the formula bar.  It seems you have 3 or 4 formulas. 

[Ranga]

Hi,

 Here's the two formulas used and screen shot shows the fileds used, I have condtion if approved count = 0 keep it blank, you can see sample data will have blank , to avoid NAN. Hope this helps.

Grand Total = Sheet1[Approved Count] + Sheet1[Reject Count]
Approved Rate = IF(Sheet1[Approved Count] = 0,BLANK() ,DIVIDE(Sheet1[Approved Count],Sheet1[Grand Total]))

[MattAllington]

It looks to me like your if statement is removing the rows with 0 an dhence they are not included in the calculation. 

Try this

Approved Rate = DIVIDE([Approved Count],[Grand Total])

Divide will handle the divide by zero case automatically. You should not use the table name in front of the measure name in your formula (best practice).  

[Ranga]

I have tried this before and gives the same result.

[MattAllington]

I just did it and it worked fine.  Maybe try again, or post your workbook