Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello everyone I have a table that looks like
NAME | Course Name | Percent Complete |
Person1 | Course1 | 50% |
Person1 | Course2 | 20% |
Person2 | Course2 | 15% |
I have a matrix where I have the names as the rows and course name as the columns and percent complete as the values. The hard part is I'm trying to create a dax formula that would filter out any name that does not have a value for Course1 while trying not to pivot the original table. So it would filter out person 2 because they never took course 1 but it would still show percentages for course 2 for those who did take course 1.
Here is what my current formula looks like, but this makes it so that it shows Course1 as the only column in the matrix
@SkinnyPotato , You can create measures like
M1 = countrows(filter(allselected(Table), Table[NAME] = max(Table[Name]) && Table[Course] = "Course1"))
M2 = countrows(filter(Values(Table[Name]), not(isblank([M1])) && [M1]>0))
M2 is the meausre you need
@amitchandak Thankyou, but isn't that just returning the count of records and not the associated percent complete?
User | Count |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |