Forum Discussion
Impactful IndividualImplicit filters remove all records?
Community SupportHi DouweMeer ,
My method only needs to create one table to put all the column headers in it,no need to create multiple tables,as there may be multiple rows that cant be matched in your matrix,those cant be matched will show blank in the matrix, there's no better ways to achieve it.Try my method,you will find it useful.
Kelly
Community ChampionFrom what I tested if you use star schema with the field in the columns being in the separate table. However with this setup whatever you put in rows has to come from the same table where filtered by the dimension from columns, otherwise you get cartesian product of the dimensions
Measure =
VAR __User = SELECTEDVALUE('Users'[User])
VAR __NrOfRows = COUNTROWS(FILTER('Table', 'Table'[User]=__User))
RETURN
IF(__NrOfRows>0,"Yes","No")
- DouweMeer
v-kelly-msft and Stachu
This does seem to be solution indeed. Although, with multiple columns, you still end up with a large second table when the original is getting larger and larger.
But if you would make a selection in the visual (red), only the distinct non related table is filtered (red), but the original isn't filtered of course (green).
I guess there is no way to manipulate the filter statement of the implicit filter to come after the DAX expression (suggestion) like with the explicit filter (assumption)?