Forum Discussion
Filtering DirectQuery table based on import mode table
MicrosoftPBI , You can create a measure like this and use in visual or visual level filter
assume ID column is key in both
Countrows(filter(TableA, not TableA[ID] in values(TableB[ID]) ) )
Super UserMicrosoftPBI , You can create a measure like this and use in visual or visual level filter
assume ID column is key in both
Countrows(filter(TableA, not TableA[ID] in values(TableB[ID]) ) )
leathardAdvocate I
What a helpful post. Thank you. I was struggling to filter a Direct Query reusable date dimension table by the date range in a transaction table. The date table has too many pivotal attribute columns to recreate in DAX, all organized into folders. This technique is also useful for limiting slicers on the Direct Query table based on the transaction date range in an import table.
When using this filter, set the filter to Greater than Zero, or something else?
Thanks for your help.
