Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
Well, you can't return a table from a measure. So perhaps a matrix visual with something along the lines of:
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
Well, you can't return a table from a measure. So perhaps a matrix visual with something along the lines of:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |