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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Kayla2020
Frequent Visitor

Apply filter to disconnected tables

Hi,

I have a matrix table based on dept and cost.  There are two disconnected tables(based on project) used in the matrix to return dept costs for selected projects. I want to create a slicer for country and cluster to filter the disconnected tables i.e if a country and cluster are selected, the disconnected table returns projects available in the selected country and cluster. 

Please how do I achieve this? Also, find attached the file.

Thank you.



projectdeptclustercountrycost
Project AHR1France5700
Project bLogistics1Poland7487
Project cProduct design2France7207
Project dTransport1Turkey7374
Project eHR1UK13018
Project fLogistics2Poland10117
Project gProduct design2Turkey6348
Project gTransport2France8902
Project hHR1Poland6061
Project jLogistics2France10677
Project iProduct design3Turkey6952
Project kTransport3UK7970
Project fHR1Poland10940
Project nLogistics2Turkey6979
Project mProduct design1Turkey11587
1 ACCEPTED SOLUTION
ThxAlot
Super User
Super User

Based on your description, TREATAS() would come into play.



Expertise = List.Accumulate(


        {Days as from Today},


        {Skills and Knowledge},


        (Current, Everyday) => Current & Day.LeanAndPractise(Everyday)


)



View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

HI @Kayla2020,

You can add variable to use values function to extract the filter effect from the target table and manually use this in your calculations expressions to apply filter effect from disconnected table.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
ThxAlot
Super User
Super User

Based on your description, TREATAS() would come into play.



Expertise = List.Accumulate(


        {Days as from Today},


        {Skills and Knowledge},


        (Current, Everyday) => Current & Day.LeanAndPractise(Everyday)


)



Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors