HOw to retrieve FIRST (N) rows while retrieving a Table from Power Pivot with Dax? What came to my mind is only to add an index column with Power Query and then to use FILTER() to enroll the SUMMARIZE()
My code:
EVALUATE
FILTER(
SUMMARIZE(
RTO_EnrolmentsAllCourses,
RTO_EnrolmentsAllCourses[CampusName],
RTO_EnrolmentsAllCourses[CoENo],
RTO_EnrolmentsAllCourses[Competency],
RTO_EnrolmentsAllCourses[Course_Finish],
RTO_EnrolmentsAllCourses[Course_start],
RTO_EnrolmentsAllCourses[CourseAttempt],
RTO_EnrolmentsAllCourses[CourseID],
RTO_EnrolmentsAllCourses[CourseName],
RTO_EnrolmentsAllCourses[Index]
),
RTO_EnrolmentsAllCourses[Index]<50)
Thanks in advance