topic Re: Return people with missing time entries in DAX Commands and Tips

Return people with missing time entries

msimmonsmcse — Thu, 23 Apr 2020 21:39:47 GMT

I have two tables : Active Members and Time Entries. They are related by MemberID. When a member puts time in their card, a row is created in the dataset for that day. I would like to get a measure that returns a list of members that are in the Active Member Table, but have no time entry rows in the Time Entry table for the filtered date in the report. Thanks!

Active Member

Member ID

Member1

Member2

Member3

Time Entry

Date	MemberID	Hours
4/21/2020	Member1	8
4/21/2020	Member2	8
4/22/2020	Member1	8
4/22/2020	Member3	8

If the above data is what I am filtering, I should get a result returned of:

Measure

MemberID	Date
Member3	4/21/2020
Member2	4/22/2020

Thanks for the assist!

Re: Return people with missing time entries

Greg_Deckler — Thu, 23 Apr 2020 22:01:05 GMT

Well, you can't return a table from a measure. So perhaps a matrix visual with something along the lines of:

Measure = IF(ISBLANK(COUNTROWS('Time Entry')),"Missing",BLANK())

See attached PBIX.

Re: Return people with missing time entries

camargos88 — Tue, 28 Apr 2020 21:20:40 GMT

Hi msimmonsmcse ,

Check this file: Download PBIX

I've created a line for those member without hours.

If you consider it as a solution, please mark as a solution and kudos.

Ricardo