Dax for matrix

Hi Ashish_Excel ,

The Problem We have

1. A Team slicer (Team A, B, etc.)
2. A Date slicer (e.g., 1.1.–1.2.2025)
3. A Matrix visual showing: Rows = Users, Columns=Dates, Values= Forecast

The Challenge We only want to show forecast values for users who

1. Belong to the selected team (from the slicer),
2. Have any timesheet activity within the selected date range.

But here's the twist.

We want to show their full forecast (across all dates), not just on the dates they have timesheets.

If a user selects Team A and sets the date range from January 1 to February 1, the matrix should display:

1. Alice → Forecast for both January 1 & 2
2. Bob → Forecast for both January 1 & 2

Even if Alice only recorded timesheets on January 1, her full forecast for both dates should still be shown. The key point here is that we are not filtering forecasts based on specific timesheet dates instead, the date filter is only used to determine which users were active during the selected period. Once a user has any timesheet activity within the range, we include their entire forecast across all dates.

Note: Please establish a relationship between the Time Sheet table and the Dim User table. Once the relationship is created, you can retrieve the required user details directly through the Time Sheet data.

FYI:

Thanks.