Percentage between two fields

[vdf]

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,

[v-yuezhe-msft · Accepted solution]

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

[v-yuezhe-msft]

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]

Hi Lydia,

Many thanks for your reply, but I am really in a muddle , 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,

[v-yuezhe-msft · Accepted solution]

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

[vdf]

Many thnks Lydia,

Solution worked, but this gives me the result for each row, is there anyway that I can have it grouped by [v_site]?

Thanks again,

[v-yuezhe-msft · Accepted solution]

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