[Help] Relationship issue: Slicer only filtering one of two Fact Tables despite Star Schema

[Help]

Hi everyone, I need some help with a data modeling issue.

I have two fact tables:

1 App_Data: Historical data from an app.

2 Manual_Fichas: Recent manual entries (started 1 week ago).

Both tables have the same structure (Date, Machine, Item, Team, Process). To filter both simultaneously, I created Dimension Tables (Calendar, Machines, Items, Teams) using ⁠DISTINCT(UNION(...))⁠ and established 1:Many relationships with Single direction (Dim -> Fact).

The problem:

When I use a Date Slicer (from the Calendar Table), it only filters the ⁠App_Data⁠ table. The ⁠Manual_Fichas⁠ visuals remain unchanged, showing the total value regardless of the date selected.

What I've checked so far:

 Both Date columns are formatted as "Date" (not Text or Date/Time).

 The relationship between ⁠Calendar⁠ and ⁠Manual_Fichas⁠ is Active.

 The slicer is definitely using the column from the ⁠Calendar⁠ table.

 I’ve tried trimming and cleaning the data in Power Query.

If the relationship is active and the formats match, why would a slicer ignore one of the fact tables? Any insights on how to debug this?

#PowerBI #DataModeling #StarSchema #DAX #Relationships