Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I have a large data set where each row is for an item. The item can have any combination of 7 different types of testing. All types of testing have a colum for when it was sent to testing, when it finished testing and the employee who tested it. So a total of 21 columns just for this data. I've added columns to calculate the aging for each type of testing if there is no finish date. Then there are columns to group the aging columns into Aging Groups.
I want to set up a visual to display the could of types of testing by aging groups and then add a drill down to add in the Employee names counting now many of each type of testing they have in each age group.
Example of data with only 2 types of testing
I'd like the end result to be something like this...
I can get to the types of testing and age groups but when I add in the employees, it changes all numbers to the totals and looks like this.... will all possible employees listed even if they didn't do any testing.
I'm at a loss. I assume that I need a relationship between the employee table and the data table...but there are 7 possible columns to link them to and I'm not sure how to do that or if it will correct all the issues I'm seeing.
Please and thank you for your input!!!
Solved! Go to Solution.
Hi @Jacqee,
Notes of what this measures is doing:
Proud to be a Super User!
HI @Jacqee,
I'm attaching a pbix file with my solution.
The final outout will be this:
Proud to be a Super User!
Thank you so much! However I've not been able to replicate your work. Some differences, the full dataset has some items that do not have all of the 7 types of testing performed so those fields are left blank. Since they don't all have the testing, I'm not able to use the "Closed" Group Name. I'm only using IDs 1, 2, and 3. I'm filtering out the blanks when I create the visuals.
I'm able to create the 1st count based on your "Count SA". I have a version of the "Count BT" which seems to work. Could you provide some additional inforamtion around that measure?
Hi @Jacqee,
Notes of what this measures is doing:
Proud to be a Super User!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
87 | |
84 | |
65 | |
49 |
User | Count |
---|---|
140 | |
114 | |
110 | |
59 | |
59 |