Forum Discussion

MicrosoftPBI's avatar
MicrosoftPBI
Regular Visitor
3 years ago
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...
General Comment
Need Help
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    3 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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]) ) )

leathard's avatar
leathard
Icon for Advocate I rankAdvocate I
2 years ago

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.