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 ...
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

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

vdf's avatar
vdf
Regular Visitor
9 years ago

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,

  • Anonymous's avatar
    Anonymous
    Not applicable
    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