Forum Discussion

avulasandeep's avatar
avulasandeep
Helper III
5 years ago
Solved

Profile Completeness Percentage

HI PowerBI Experts,   i have one issue ....need to find the  Percentage of Profile Completeness for each employee  Here i have attached  sample report with data    in this report if the profile c...
Need Help
Show and Tell
Tips and Tricks
  • v-kkf-msft's avatar
    v-kkf-msft
    5 years ago

    Hi avulasandeep ,

    Try the following formula:

    % of Profile = 
1-DIVIDE( 
    CALCULATE(
      COUNTROWS('Employee Unpivot data'),
      FILTER(
        'Employee Unpivot data',
        'Employee Unpivot data'[Value] in { 0, BLANK(), "NA" }
      )
    ),
    COUNT('Employee Unpivot data'[Employees])
  )

     Create another measure, and then apply it in the Data colors of the bar chart.

    color = 
Switch( 
  TRUE() , 
  [% of Profile]=1 , "Green",
  [% of Profile] <.75 , "red",
  [% of Profile] <.99 , "Yellow"
)

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.