Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
So I have 2 different data sources in one .pbix file. The first data source is from an excel file and the second data source is from a sharepoint list. These 2 data sources are very similar to each other excluding the values of course. Both of these data sources have a District table and inside it is the 'District Name' column. Now what I want to do is put the 'District Name' column to a slicer so I can filter my visuals based on it but of course it will only filter the ones that came from the same data source and not the ones from the other data source. So my question is how can I make it so that when I put 'District Name' from one data source to a slicer, it will filter both data sources?
Any help would be greatly appreciated!
Solved! Go to Solution.
@Anonymous , If they are not joined . Then you can that in measure
Measure =
calculate(sum(Table2[Name]), filter(Table2, Table2[District] allselected(Table1[District]) ) )
Also check Treatas
https://docs.microsoft.com/en-us/dax/treatas-function
Other I create a new dimension table and join with both tables and use that
distinct(union(distinct(Table1[District]),distinct(Table2[District])))
Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19
@Anonymous , If they are not joined . Then you can that in measure
Measure =
calculate(sum(Table2[Name]), filter(Table2, Table2[District] allselected(Table1[District]) ) )
Also check Treatas
https://docs.microsoft.com/en-us/dax/treatas-function
Other I create a new dimension table and join with both tables and use that
distinct(union(distinct(Table1[District]),distinct(Table2[District])))
Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |