Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Drilling doesn't work

Original Post - https://community.powerbi.com/t5/Desktop/Monthly-Total-Open-Cases/mp/1284325#M561428 Can anyone advise how to get the following measurement to drill correctly? In my previous ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    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

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

The 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

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee
    6 years ago

    Been there.  Glad it's working.

     

    Regards,

    Pat