cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Zaky Member
Member

Calculate Percentage of Training Status

Hi,

 

I have a column of Training Category (Self Request Training, External e-Learning, e-Learning Training, Internal Training).

How can I create a measure to calculate the percentage of each training category by completion status (Completed or In Progress)? and I want to visualize it in donut chart.

 

Staff NameTraining CategoryTraining Status
Staff AInternal TrainingCompleted
Staff BInternal TrainingCompleted
Staff CInternal TrainingCompleted
Staff DInternal TrainingCompleted
Staff Ae-Learning TrainingCompleted
Staff Be-Learning TrainingIn Progress
Staff Ce-Learning TrainingCompleted
Staff AExternal e-LearningIn Progress
Staff CExternal e-LearningIn Progress
Staff BSelf Request TrainingIn Progress
Staff CSelf Request TrainingCompleted
Staff DSelf Request TrainingCompleted

 

Pls help.

 

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Calculate Percentage of Training Status

Hi,

 

You may download my PBI file from here.

 

Hope this helps.

 

Untitled.png

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Calculate Percentage of Training Status

Hi,

 

You may download my PBI file from here.

 

Hope this helps.

 

Untitled.png

View solution in original post

Zaky Member
Member

Re: Calculate Percentage of Training Status

Thanks Ashish. It's work.

Super User
Super User

Re: Calculate Percentage of Training Status

You are welcome.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 114 members 1,683 guests
Please welcome our newest community members: