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]) ) )
Thank you very much.
Instead of having to create a DAX table, I was able to use this DAX measure and use it on the table level as filter. The PBI cloud refresh works, thanks!
Can you provide the solution here so others can benefit from this
