Forum Discussion
PBI perform inner or outer join
Hello everyone, I would like to aks you about data modeling in Power BI. If I choose my tables set like star schema at model I dont understand how to set inner join or outer join. If I will be speci...
Hi ondrej-cdc ,
I feel you just need to join Dim table to Fact table on period_key with uni-directional filtering.
Now you just need to take the field from Dim table into slicer/filter. Non-matching values from Fact table would be automatically neglected in the slicer.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! |
Hello Anand24, I am sorry, but I think the issue was solved, but a had applied an filter to distinctcount 😞 If I have set both-directional join, the non matching values are still here :(.
And what makes you choose a bidirectional join?
It is from Anand post. Is It not right?
I feel you just need to join Dim table to Fact table on period_key with uni-directional filtering.
Ondrej
No, he suggested unidirectional.
