Jun 07 2020 07:42 PM
Jun 07 2020 09:49 PMSolution
@Justin_Yost Assuming you are on a Windows system (i.e. not Mac), make sure that "Add this data to the Data Model" is checked (see picture, bottom left).
Then create the PT as in your example, but leave out the last column. Then add a 'Measure' to the table in the
Name the measure and enter the DAX formula required
Add the Measure field to the PT and format it as a percentage. Then it should look like this:
The attached file contains the example shown above.
Oct 04 2023 11:41 AM
@Riny_van_Eekelen I love this concept, and I learned something new! Thank you for this post.
I am trying to leverage this functionality with my data set, but I am struggling to set it up in a way to get what I need from it. Hoping you can assist.
I am looking for a compliance rate for teammates within their specific Default Group. My data is pulled so that I have the Teammate and Default Group with their weekly timesheet hours submission. The goal is to be at least 40 hours per week.
Then, we calculate what the compliance rate is based off of the number of teammates that submitted 40+ hours/# of Teammates in the Group.
Instead of using a manual calculation, I was hoping to use this method. However, I cannot figure out how to get the data setup and create a usable formula. Any assistance would be greatly appreciated!
Oct 04 2023 10:10 PM
@MandiA15 Not sure I follow, and since the last post a lot has happened to Excel. Perhaps the Data Model / DAX measures route is not needed in your case.
What Excel version are you using? What platform? Can you share a file (without sensitive information) via Onedrive or similar?
Oct 05 2023 07:27 AM
@Riny_van_Eekelen Thank you for your quick response!
To answer your questions: