I have a matrix being used to show timesheeting data. For a specific view, I need to use a table that can't have a relationship to my date table. As a workaround, I am trying to use a measure that assigns 1 to rows within the selected date range, then filtering the matrix on 1. The problem I'm having is the Matrix doesn't show any data for certain time periods (no idea why), but when I 'Export Data' to get a CSV, the data is identical to the working matrix if I slice by the table's own date field.
I can't for the life of me figuring out why the Matrix visual isn't showing data that can be extracted by the visual. When using another after market matrix, it displays the data as expected, but there are drawbacks with its use.
The matrix structure:
Rows:
TaskName
ResourceName
Columns:
Date Range
year
quarter
month
day
Values:
Work
ActualWork
The measure filtering the table:
measure =
VAR mindate = MIN(Date[Date Range])
VAR maxdate = MAX(Date[Date Range])
RETURN
IF ( MIN(Table1[Date Range]) >= mindate &&
MAX(Table1[Date Range]) <= maxdate,
1,0
)
Time slicer
Date[Date Range]
