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.

amitchandak's avatar
amitchandak
Super User
5 years ago

avulasandeep , You can create a color measure based on %

 

Example

Switch( True() ,
[Percent] =1 , "Green"
[percent] <.75 , "red",
[percent] <.99 , "Yellow"
)

 

Use that in conditional formatting with the field value option

refer my video on that https://www.youtube.com/watch?v=RqBb5eBf_I4

avulasandeep's avatar
avulasandeep
Helper III
5 years ago

Hi amitchandak ,

 

Actually it is not regarding color coding  .it is regarding Profile percentage completion in Percentage ...need the profile completion percentage  of each employee  whether the profile completion was completed or not ....if completed how much completed with all rows for respective employee then  he /she  completed 100%  and if not How much % not completed?

Need Profile Completion Percentage....if possible please let me know the formula for each employee profile percentage.

 

Need:
1.Profile completion Percetage % per employee
2.Percentage range ie.,
   0% - 74%, 75%-99%,100%

 

Thanks in advance 

sandeep

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    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.