Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Matrix does not display data without relationship

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]

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous,

    Can please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng