Wrong percentage

[FSALE]

Hello guys,

I have a problem with a percentage. 

I have 5930 calls for 1426 bookings so the transformation is 24,04% (Excel is OK). But in Power BI, the app tells me 23,83% and I don't know why.

This is the code : 

% TRANSFO = if(Feuil1[APE]>0;Feuil1[RDV]/Feuil1[APE])

Can you help me with this problem ? 

Thanks a lot !

Have a good day. 

[amitchandak]

Seems strange. But at first try

% TRANSFO = divide(Feuil1[RDV]/Feuil1[APE])

Or 
% TRANSFO = divide(Feuil1[RDV]*1.0/Feuil1[APE])

[FSALE]

Thanks for your answer.

I've the same result with the divide function. 

I don't understand where the problem is cause all my other percentage in the report are correct. 

I use the "average" instead of "resume/not resume" when I use the column, maybe it's wrong.

[amitchandak]

just check no filter applied to visual you are checking this. Also, check the count of rows here and in excel are same

[FSALE]

Hello,

No filters and the number of rows are correct. 

It's only on this measure. I'm going to search and if I find an answer I'll tell you all. I'll try with new data this day, maybe the problem is going to be solve. 

Thanks for your help 🙂

[FSALE · Accepted solution]

I've found the solution while looking on Reddit.

My problem was that I was thinking in an excel way. I was using column and not measure to calculate my %.

Thanks alot for your help !

Have a good day.