Return people with missing time entries

[msimmonsmcse]

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!

[camargos88]

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

[Greg_Deckler · Accepted solution]

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.