Forum Discussion

FSALE's avatar
FSALE
New Member
6 years ago
Solved

Wrong percentage

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. 
Need Help
  • FSALE's avatar
    FSALE
    6 years ago

    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.

     

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Seems strange. But at first try

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

Or 
% TRANSFO = divide(Feuil1[RDV]*1.0/Feuil1[APE])
    • FSALE's avatar
      FSALE
      New Member
      6 years ago

      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's avatar
        amitchandak
        Super User
        6 years ago

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