Forum Discussion

koorosh's avatar
koorosh
Icon for Post Partisan rankPost Partisan
6 years ago
Solved

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.    
  • FarhanAhmed's avatar
    FarhanAhmed
    6 years ago

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

     

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

  • Anonymous's avatar
    Anonymous
    6 years ago

    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)

FarhanAhmed's avatar
FarhanAhmed
Icon for Community Champion rankCommunity Champion
6 years ago

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