Profile Completeness Percentage

[avulasandeep]

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 completes all rows it has to show 100%  and if Profile having  blanks or 0 or null or NA(not available) it will be less than 100% . This percentage range colors has to show in color coding as below
if Profile completeness show 100% ,"Green"
if Profile completeness show 75%  to 99%,"Yellow"

if Profile completeness show 0%  to 75%,"Red"

for this color coing i need range of Percentage as above.

So finally i need percentage of profile completeness as per range for each employee
example:
Person2 has only  100 % completeness  profile then for Person 2 it  has to show 100% and Green color

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

Please find the below link for file.

https://drive.google.com/drive/folders/1sbp5oBTpFFXX1eah0THC8ql1BKZsegdU?usp=sharing

Download for File/excel 

Thanks in Advance 

Sandeepavula

[v-kkf-msft · Accepted solution]

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.

[avulasandeep · Accepted solution]

Thanks @v-kkf-msft  it is working

[amitchandak]

@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]

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 · Accepted solution]

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.