Forum Discussion
missing value
Hello Experts, Have a list that shows partners enrolled in courses, how to make a report that shows missed courses by each partner.
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]))cross join expect 2 inputs ,,,, you are including both columns in ALL statement... separate both columns
CrossJoin( all(Sheet1[Partner]), all(Sheet1[Course Name]))
HI koorosh ,
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
12 Replies
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]))Why get error Amit?
cross join expect 2 inputs ,,,, you are including both columns in ALL statement... separate both columns
CrossJoin( all(Sheet1[Partner]), all(Sheet1[Course Name]))
1- you need to separate Course from Orignal table, i.e. a table that contains all courses. From this table you can create course table like this.
Course = SUMMARIZE(Partner,Partner[Course])2- Then join this table with your main table.
3- Create a matrix visual
4- Put Partner from partner table in Rows
5- Put Course from course table(new summarized table) in columns
6- create a measure for missed count
Missed Course = IF(COUNT(Partner[Course])>0,BLANK(),1)7- Drop this measure in Values and see the results
