Forum Discussion
Drilling doesn't work
Please try this measure added to your table visual on the drillthrough page. I reproduced your scenario on my end and this appears to get your desired functionality.
IsActive = VAR mindate = MIN ( 'Date'[Date] ) VAR maxdate = MAX ( 'Date'[Date] ) RETURN CALCULATE ( COUNTROWS ( Employees ), ALL ( 'Date' ), OR ( Employees[EndDate] >= mindate, ISBLANK ( Employees[EndDate] ) ), Employees[StartDate] <= maxdate )If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Community SupportHi Anonymous ,
Your image shows that you have added a meausre into drill-through field. So this page is a detailed one. You need to click the values from another page then it will jump to this page.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
v-xuding-msft this is the original visualisation:
I want to drill-through by the Month Date and see the list of active persons and see the list of active persons, which is not working as below (it is returning all PERSON_ID instead of relevant active persons for the month)