All values

[koorosh]

Hello Experts, Have a list that shows partners enrolled in courses, how to make a report that shows the partners enrolled all courses.

[amitchandak]

@koorosh , Try a measure like

measure =
var _cnt = calculate(distinctCOUNT(Table[Course]))
return
countx(filter(summarize(Table, Table[PARTNER], "_1", calculate(distinctCOUNT(Table[Course]))), [_1] =_cnt),[Partner])

[koorosh]

Thanks, Amit, the measure returns a value, how we can get a table that returns all partners that took all courses? Like what we did for missing courses as following dax:

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

[amitchandak]

@koorosh , Please find the attached file after signature. Added new table and create two new visual table on right

[amitchandak · Accepted solution]

@koorosh , In a table visual put this measure with partner

[koorosh]

Could you please let me know what expression we should write that says: create a table with summarize function (including just one partner column) with filter function that checks the number of total courses equal with the number of courses a partner enrolled.

[koorosh]

Table test =

var cnt = CALCULATE(DISTINCTCOUNT('Completed Courses'[Course Name]),ALLSELECTED())

return

FILTER(

summarize(

'Completed Courses','Completed Courses'[Partner Name],

"courses attended",DISTINCTCOUNT('Completed Courses'[Course Name])),

[courses attended] = cnt

)