Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

One slicer for 2 different data sources

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!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.