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

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

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.

Top Kudoed Authors