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

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

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

Zaky Regular Visitor
Regular Visitor

Re: Calculate Percentage of Training Status

Thanks Ashish. It's work.

Super User
Super User

Re: Calculate Percentage of Training Status

You are welcome.