missing value

[koorosh]

Hello Experts, Have a list that shows partners enrolled in courses, how to make a report that shows missed courses by each partner.

[amitchandak · Accepted solution]

@koorosh , Create new table like

New table =except(crossjoin(all(Table[partner]),all(Table[Course Name])), selectcolumns(Table,"partner", Table[partner], "Course Name",Table[Course Name]))

https://docs.microsoft.com/en-us/dax/except-function-dax

[FarhanAhmed · Accepted solution]

cross join expect 2 inputs ,,,, you are including both columns in ALL statement... separate both columns

CrossJoin( all(Sheet1[Partner]), all(Sheet1[Course Name]))