Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi
I have a forms table that is collecting data for each employee per day. I have a 1 to many relationship to employee base table.
I did a match using related table function to establish employees that responded vs not.
Read this through a couple times. Hard to understand what is going on here. MatchEmployee, is that a column, a measure? In what table? Not sure I understand where date comes into this.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi
Thanks for your reply. I have DimEmployee table linked to FormsEmployee Transaction table.
When I use the date slicer, it filters the FormsEmployee table because there is a date column but doesnt exist in DimEmployee.
Its 1 to many relationship, if I want a total base of employees I apply dax over the DimEmployee to get Total count.
I apply dax to FormsEmployee to get total number of employee responses (When completing MS Form).
So TotalCount = 500, Employee Responses = 250. But I would like to know who where the employees that did not respond meaning difference of 250 employees that do not match to FormsEmployee table when filtering by a date slicer.
Thanks. And if I select date slicer to a specific day, will this dynamically change (for the ones that did not respond)because the date coumn exists in FormsEmployee table and not the DimEmployee (Unless its a many to many scenario where I have to introduce a date in DimEmployee and use composite key?)
Hi Thank Its all working as per your recommendation and thanks for the videos already watching!!
Hi
I tried this, but returns blank as a count
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
32 | |
14 | |
13 | |
12 | |
9 |