relationship cross filter direction

Question

HiI don't undertsand this behaviour in my model. I have this relationships&nbsp;&nbsp;One Oferta can have many Ofertantes but could be records in Ofertas than they are not yet in Ofertantes obviously and so on I select cross filter direction single.&nbsp;If I don´t add any fields of Ofertantes in my report I have records until 17-04-2017&nbsp;&nbsp;But when I add to my report the BajaMedia field of Ofertantes in my report disappear many records. All the records of february, march and april&nbsp;&nbsp;and followed when I examine the relationship again it shows like this other way&nbsp;&nbsp;Any idea please?&nbsp;regards&nbsp;&nbsp;

v-huizhn-msft · Answer

Hi&nbsp;kintela,Please set the&nbsp;cross filter direction to both and check if it works fine, if it doesn't, could you please share your .pbix file for further analysis.Best Regards,Angelia

kintela · Answer

Hi&nbsp;v-huizhn-msft&nbsp;With cross filter in Both I lose a lot of records.&nbsp;Here is the .pibx:&nbsp;https://dl.dropboxusercontent.com/u/917753/Ofertas.pbix&nbsp;Thanks

anonymous · Answer

Hi,&nbsp;I was interested in knowing what was the final solution and how you cam to it? Trying to get a better understanding of the Cross filter direction!&nbsp;Regards,&nbsp;&nbsp;

Forum Discussion

relationship cross filter direction

3 Replies

Related content

Bi-Directional filtering

Relationship

Power BI: Understanding Many-to-Many Relationships, Bi-Directional Filtering, Ambiguous Paths

Relationship (Direct Query)

Relationship Issue