Forum Discussion

victorhstoytche's avatar
victorhstoytche
Regular Visitor
3 years ago

Help with filtering values on another directquery table

Dears,   I am struggling with the following:   I have two tables. Table A is Import. Table B is Direct Query. The connection is with a key (Brand-Month), where Table A filters many to many Table ...
Date
DAX
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago
where Table A filters many to many Table B.

That's a light red flag.  Please show more of the data model.

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523