Complex Matrix Help

[SkinnyPotato]

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

Filter =

CALCULATE('Table'[Percent-Complete],

    FILTER('Table',

        IF([Course ID] = "Course ID" && ([Percent Complete] <> 0 && NOT(ISBLANK([Percent Complete]))),

            [Percent-Complete]

        )

    )

)

[amitchandak]

@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

[SkinnyPotato]

@amitchandak Thankyou, but isn't that just returning the count of records and not the associated percent complete?