Forum Discussion
xliu1
Helper II
Helper IICommon 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 ...
az38
Community Champion
Community ChampionHi xliu1
you need to create relationships between tables by this filed via Manage relationships tool
xliu1Thanks. 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!
- az38
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
- xliu1
Thank you!