I have a matrix whose columns are a subset of the rows in table, which is accomplished by filtering that table by one of it’s fields. This works great when I use a value source from a related table. However, when I add a second unrelated value, my filtering no longer works and all columns are displayed.
I think I understand why this is happening as the DAX generated looks roughly like this:
x = SUMMARIZECOLUMNS(
Detail table has ColumnName and Score and is related to ColumnSource on the ColumnName field.
ColumnSource has a field named Type that identifies the subset of columns that I want visible. Other columns may have data in Detail, but I only want to see the subset.
In the absence of the “test”, “x” line, Type filters ColumnSource and only the selected columns are displayed along with the Score values. When that line is added, “x” has results for all rows of ColumnSource, not just the filtered ones.
Any ideas on how to solve this? Appreciate any help.