Filter issue between tables

Kraftfood · ‎09-05-2022

Hello, I have an issue between 2 tables within the same model. I am following a star schema and the 2 tables are not the central ones.

See several screenshot below (I could not attach files). If you click on "Germany" from the right table (that shows Ratio Ticket / staff per country), the results in the left table is 100% everywhere for Germany.

As of now I am setting the cross filter direct as single in order to avoid this issue but I would like to obtain the correct figures.

Do anyone has an idea of how to do that? I tried with the crossfilter DAX formula but did not succeed. I hope the screenshots help, it's very confusing without the files or the description of the screenshots. Do not hesitate to ask questions

Please see links to the power bi example.

Power BI: https://1drv.ms/u/s!AkGwzt_UiPRCg3DqEgmQkIJQZMVm?e=STjAnm

Excel Base: https://1drv.ms/x/s!AkGwzt_UiPRCg28GaAM8tKuKPAEQ?e=RvQAG0

Thanks in advance!

parry2k · ‎09-06-2022

@Kraftfood cannot access the file. Seems like a sharing issue.

✨ Follow us on LinkedIn and to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k · ‎09-05-2022

@Kraftfood if possible share pbix using 1 drive or google drive. Seems like it is a relationship issue that needs to be fixed.

✨ Follow us on LinkedIn and to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Kraftfood · ‎09-09-2022

Hi parry2k,

I have added new links to the Power BI from 1 drive. These should work. Let me know 🙂