CODEWITHSUNDEEP
powerbidax
Red Vibes
Red Vibes

Reputation: 79

Show value as percentage in power BI

I have a data -

E no e name met with MD as
55467 ALFRED CLS
324 ROBERT CCSG
9876 SOVIYY as lady employee
536 CREFY CLS
789 LOYED OSDS
86 ZIKO.M CCF

and I was asked to show the % of employees who have met MD and show them in card visualisation powerBI. I am new to power BI and I have to complete this project for my final year and I got stuck. Please help me in completing this. Please share if u have any code in DAX to perform. Thanks in advance!!!

Upvotes: 0

Views: 724

Answers (1)

Nandan
Nandan

Reputation: 4945

Based on the limited input dataset which you have Are there any blank values in the met with MD as column for any employee? If yes, then the task would be

Distinct count of employees where Met with MD column<>''

You can use the below DAX functions to achieve it:

  1. Calculate, count or distinctcount , filter and finally Divide for %

Upvotes: 1

Related Questions