Forum Discussion
One Filter for Shared Column and Values Across Multiple Tables
Hi there, I have multiple tables all linked via an ID column. The data is all pupil information. There is a single pupil table with no Academic Year table, linked to tables such as attendance...
Hi MattSwan ,
Do you consider designing its relational model as a star architecture
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
https://radacad.com/power-bi-basics-of-modeling-star-schema-and-how-to-build-it
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.