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 ...
xliu1Helper II
Helper IIThanks. 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
Community Champion
Community Championyou 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!