Forum Discussion

fbittencourt's avatar
fbittencourt
Helper IV
8 months ago
Solved

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 LI...
Need Help
  • amitchandak's avatar
    amitchandak
    8 months ago

    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. 

amitchandak's avatar
amitchandak
Super User
8 months ago

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. 

fbittencourt's avatar
fbittencourt
Helper IV
8 months ago

Thank you again to be always disposal to help all members of this community!!