Forum Discussion

koorosh's avatar
koorosh
Post Partisan
4 years ago
Solved

All values

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

 

Need Help

6 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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's avatar
      koorosh
      Post Partisan
      4 years ago

      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]))