cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Re: Help With Missing Timesheet Counts

@yingyinr  Unfortuntately I'm still getting (Blank)Missing Count showing up as seen in the screenshot below. I feel like we're so close. I tried a few things somewhat based on your previous measure, but haven't had any luck yet. I'll keep plugging away and reading up more on DAX to see what I can come up with.

 

Thanks for your help so far and any additional help you may provide! 

 

Blank Showing2.PNG

Highlighted
Microsoft
Microsoft

Re: Help With Missing Timesheet Counts

Hi @DJLight890 ,

Please share some sample data in table Timesheet Hours and Employee List or your pbix file with us, then we can adjust the formula of related measures based on your scenario. Thank you.

Best Regards

Rena

Highlighted
Helper I
Helper I

Re: Help With Missing Timesheet Counts

@yingyinr  Yes, here is the link to the file. I haven't done this on here before, so let me know if you have any issues getting it.

 

PowerBI File

Highlighted
Microsoft
Microsoft

Re: Help With Missing Timesheet Counts

Hi @DJLight890 ,

Please update the formula of measure "Missing count" as below:

Missing Count = 
VAR _selections =
    ALLSELECTED ( 'Timesheet Hours'[Period Name] )
VAR _countofPeriod =
    COUNTROWS ( _selections )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( 'Employee List'[Employee Name] ),
        'Employee List'[Timesheet Required] = "Yes"
    ) * _countofPeriod
        - CALCULATE (
            COUNT ( 'Timesheet Hours'[Period Name] ),
            'Employee List'[Timesheet Required] = "Yes",
            FILTER (
                ALL ( 'Timesheet Hours' ),
                'Timesheet Hours'[Period Name] IN _selections
            )
        )

Missing count.JPG

 

 

Best Regards

Rena

View solution in original post

Highlighted
Helper I
Helper I

Re: Help With Missing Timesheet Counts

@yingyinr  Oh my goodness, thank you so much!!! That worked wonderfully! Looks like I need to learn more about VAR because that has been appearing a lot. Thanks again, I realy really appreciate your help!

Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors