Chain of joins in star schema not working as expected

[lg01]

I have a data set with multiple tables joined in a star schema, with a central fact table and multiple dimenssion tables. One of those dimmesion tables also has a table with different types associated to that dimmesion. So it would be something like 

client (fact) 1- * transactions (dimension) 1- * transaction type

I can go right now and select a client and see all the transaction types that client has. However, when I create a slicer of the transaction types, and select one transaction type expecting to get all the clients who have that transaction type, then it does not work. It does not show anything in the client table.

I tried adding another join from transaction type directly to client; but it does not work. It errors because it becomes a revolving join. 

How can I answer that question of how many clients have the type of transaction selected?

[v-echaithra]

Hi @lg01 ,

I hope the issue is resolved. If further assistance is still required, we are available to support you and are committed to helping you reach a resolution.

Thank you.

[v-echaithra]

Hi @lg01 ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[pbiuseruk · Accepted solution]

Hi,

It's most likely a modelling issue somewhere - check you're joining on the correct fields and look at the data view to confirm the IDs exist as you expect.

If you want a really quick fix (not best practice) - it would be to go into your power query editor, go on the Transactions Query you have and then merge in the Transaction Type (and expand the necessary field you want to filter by) - Close and Apply.

Then just make a table with some of the fields from Customers and add the slicer from the Transactions table (the newly merged one you just made from Power Query). That should work.

The only reason it wouldn't is if the relationship isn't correct between Customers and Transactions. If you post some dummy data, I can take a look and advise.

If it does work, then that means there was an issue with the relationship you set up between Transactions and Transactions Type.

Hope that helps.

[v-echaithra]

Hi @lg01 ,

Thank you @pbiuseruk  for your inputs.

We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Best Regards,
Chaithra E.