Forum Discussion
Solved
Filtering DirectQuery table based on import mode table
Hi! I have two tables: Table A (directquery from cloud dataset), contains most KPI-s and value X Table B (import mode SQL query), contains value X I need to show all Table A data except rows wh...
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]) ) )
amitchandak
Super User
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]) ) )
When using this filter, set the filter to Greater than Zero, or something else?
Thanks for your help.