Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Zaky
Helper IV
Helper IV

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
Ashish_Mathur
Super User
Super User

Hi,

 

You may download my PBI file from here.

 

Hope this helps.

 

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Hi,

 

You may download my PBI file from here.

 

Hope this helps.

 

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Thanks Ashish. It's work.

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.