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
hi mahoneypat
this does not work either.
when i drill-through on a month, July2020 for example with 312 active persons, we drill-through to the page where the table shows list of persons with 'IsActive' measure under the 'Drill through' on the visualisation. It does not work because there is over 30,000 rows. This does not make sense when there are 312 active persons in the month.
Any ideas?
I appreciate your continued effort.
Dan.
Microsoft EmployeeThe IsActive measure worked on my mockup file. Can you provide a pbix file that replicates what you are seeing and share a link to it? Not sure what else to try without that.
Regards,
Pat
mahoneypat thanks so much, I started all over again and it works!!
Whatever trouble I was having before isn't there now. All working 😎
- mahoneypat
Been there. Glad it's working.
Regards,
Pat