Forum Discussion
Date table not filtering related table correctly
Please find the Power BI file here.
I am stumped on this issue. I have a date table (Calendar Time 15) that has dates every 15 minutes. I have related this table to Daily Roster (3) based on a column called "Custom". The issue is displayed in the tab "Duplicate of Utilization by Time 15." The table on the right-hand side shows the date/time from the Calendar Time 15 table. Then I bring in Employee Name from my Daily Roster (3) table. This table shows that the Calendar Time 15 table is not correctly filtering the Daily Roster (3) table.
The first name in the table (Brown...etc) should show up at 4:00AM. If I go to the Daily Roster (3) table and filter that "Custom" column there for 12/26 4:00AM, Brown...etc shows up. But in the table that's related his name doesn't show up. I'm lost on the reaosn why. I created a new table Daily Roster (4) that merges the two tables I'm referencing together to see if there was some sort of slight difference between the date/time combinations, but they all matched. So I'm lost.
Hi Anonymous ,
Based on my test, we think the problem maybe occured in the relationship between "Tasks (3)" and "Calendar Time 15", when the 'Calendar Time 15' equal to 12/26 4:00 AM, because the relationship to the 'Tasks(3)'[Start 15 Time], and there are a filter 'Tasks(3)[RESOURCE_TYPE] equal to "ALA", so consider the two condition, there are no such Employee Number (022327000).
We can try to remove the relationship between 'Calendar Time 15' and the 'Tasks (3)', it should show the correct result.
If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that you have shared.
Best regards,
6 Replies
- mwegener
Most Valuable Professional
Hi Anonymous,
there is no corresponding line in task (3)
mwegener I guess I'm not the best with relationships, but why would that matter?
So if I filter Tasks (3) by resource type, that should then filter the Employee (3) table by employee number. Which would then filter daily roster (3) by those matching employee numbers. So currently my daily roster (3) table should contain multiple rows of employee numbers that match my filter from Tasks (3).
Then shouldn't my filter from the Calendar Time 15 table be separate? The only thing I'm passing from there is a date/time filter of 12/26 4:00 AM.
So my already filtered table from the first process, would then be filter further just for rows matching 12/26 4:00AM in the "Custom" column of Daily Roster (3).
Am I thinking of that wrong?
Ultimately, I want to be able to filter by various dimensions in the Tasks(3) table. Then I need a measure to count the corresponding number of rows in the Daily Roster (3) table as well as another measure to count the number of rows in Tasks(3) all by specific times laid out in the Calendar Time 15 table.
- mwegener
Hi Anonymous ,
Your Tasks (3) table is filtered on the "Resource_Type" = "ALA" and "Start 15" = "12/26 4:00 AM". There is no corresponding employee for these filter values.
