Forum Discussion

vdf's avatar
vdf
Regular Visitor
9 years ago
Solved

Percentage between two fields

Hi,

 

I am trying to get a percentage between two fields but for some reason is not given the correct result:

 

Pct Total = IFERROR(1-(Repeat / Contact),0) I am getting the following result

Pct Total = IFERROR(1-(6861 / 22772),0) - NaN

I also get

Pct Total = IFERROR(1-(75 / 278),0) - 1164%

 

Any help is very much appreciated,

 

Thanks,

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi vdf，

    Please right click your fields(1stContact_7,Repeat_7,Column 3,Pct Total) in the Field Panel as shown in the following screenshot, then choose"Don't summarize", then your Column 3 and Pct Total should show correctly.



    Thanks,
    Lydia Zhang

  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi vdf，

    Please create new measures using the following formulas.

    SumRepeat_7 = SUM(data[Repeat_7])
    Sum1stContact_7 = SUM(data[1stContact_7])
    Sum1stContact_7 = SUM(data[1stContact_7])

    Then create a visual as follows and check if it resturns your desired result. For more details, check this modified PBIX file.


    Thanks,
    Lydia Zhang

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi vdf,

    I test the scenario as yours, but I am not able to reproduce your issue. You can check the example in the following screenshot, for more details, please review the attached PBIX file.


    In your scenario, what is the data type of the two fields(Repeat and Contact)?  And what is the result if you use the following formula to create new column instead?

    Column 3 = IF(Table3[Contact]=0,
   0,
   1-(Table3[Repeat]/Table3[Contact]))



    Thanks,
    Lydia Zhang

    • vdf's avatar
      vdf
      Regular Visitor
      9 years ago

      Hi Lydia,

       

      Many thanks for your reply, but I am really in a muddle :smileysad:, I am new to Power BI, so all the help is greatly appreciated. I've tryied to 'copy' your formula but still do not work, I enclosed what I've done ftr-community, could you check where I am wrong, please?

      Kind regards,

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi vdf，

        Please right click your fields(1stContact_7,Repeat_7,Column 3,Pct Total) in the Field Panel as shown in the following screenshot, then choose"Don't summarize", then your Column 3 and Pct Total should show correctly.



        Thanks,
        Lydia Zhang