Forum Discussion
Dynamic filter on a table, then EXCEPT on it
Hello the Power BI community, after a lot of work, i'm stuck. I tried several AI help in order not to bother humans, but they circle their answers eventually. Here is what i'm trying to achieve : ...
Hello,
you're probably right. Should i try to remove this post and recreate it in DAX solutions' category ?
Here are a few examples of data :
3 rows of Table 1 :
Number1 | Filter1
5239 | APAOR
8558 | APCA
4536 | DIS
3 rows of Table 2 :
Number1
5239
4536
8426
Expected results :
if my Filter1 is set on APAOR, i expect the IntermediaryTable to show
Number1
5239
and the EXCEPT to show
Number1
4536
8426
Thanks for your help.
dufoq3
Community Champion
Community ChampionIf you have distinct values in Table1 [Number1] column, create One to Many relationship between Number columns and you can start using filter as described.