Forum Discussion
Solved
Common filters for visualizations using columns from different datasets
I imported three datasets into Power BI: ENRL_MODALITY, COURSE_FTE_SCH, FLG_DL_ENRL. All three datasets have the same column "Term", which has the same format. What I want to do is to pull different ...
Hi xliu1
you need to create relationships between tables by this filed via Manage relationships tool
Thanks. This works. But it looks like I can only manage relationship for one column at a time. What if I need to set up multiple filters: Term, Campus, College, etc. to apply to all three datasets? Thanks for any advice!
you can create active relationships only by one field.
for any other logic you should use USERELATIONSHIP function https://docs.microsoft.com/en-us/dax/userelationship-function-dax in your measures or column statements
Thank you!
