Forum Discussion
Filter a third table without changing the relationship direction
Hi Guys !!
I have three tables on my model where I have two columns to filter from the table REF AED to the table REF PROJET 3º table , I have changed the relationship between REF AED AND REF LISTE PROJET and works perfectly, but I need the same solution without changing this relationship.
I just need to showed as a table, I tried to used crossfilter but I need an argument.
I need to use ONLY two columns from REF AED - SH proprietaire and STATUS PROJET
Tks all again!!
fbittencourt , if you do not change relation between REF AED AND REF LISTE PROJET , you can not show REF AED - SH proprietaire and STATUS PROJET as "Not Sumamrized" field. You can show them as measure
maxx(filter('REF AED', 'REF AED'[Key] in values('REF LISTE PROJET'[Key])), [STATUS PROJET])
Else, change it to bi-directional if it allows.
3 Replies
fbittencourt , if you do not change relation between REF AED AND REF LISTE PROJET , you can not show REF AED - SH proprietaire and STATUS PROJET as "Not Sumamrized" field. You can show them as measure
maxx(filter('REF AED', 'REF AED'[Key] in values('REF LISTE PROJET'[Key])), [STATUS PROJET])
Else, change it to bi-directional if it allows.
Thank you again to be always disposal to help all members of this community!!
Can you please explain a little bettere what you are asking? Show pictures please and identify the issue
