Forum Discussion
Solved
How to build proper model
Hello experts, I wanted to practise building the model correctly a little. I have a sample data set of music reviews. I have tables such as: reviews, artist, content, genres, labels and in additi...
PijushRoy what you say about this model?
I've created a "bridge table" between dimensionals tables and fact table review.Hi Konrad909090
Bridge table or lookup table is also fine but when you are using a both way relationship and want to create visual with multiple table, there are chance to filter out other table data.
Please validate, if works fine then stay with this approach
Hi Konrad909090
Please find the proper data model, find the attached PBIX file.
Please let me know if you face any issues.