Skip to main content
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

New Member

Selecting aggregate column on one table sets filter on different table

Hello Everyone,


I am super green to Power Bi (I know DA and SQL to a decent degree) and I am trying to build a report that provides a high level overview (left table), then breaks down the aggregate on the right table. 


Below is the DAX query I used to make both the Completed Consents and Incomplete Consents column

Completed Consents =  CALCULATE(COUNTROWS(FILTER(ltit_userconsent,ltit_userconsent[Consent Status] ="Complete")))

Incomplete Consents =  CALCULATE(COUNTROWS(FILTER(ltit_userconsent,ltit_userconsent[Consent Status] ="Incomplete")))


The right table filters properly depending on if you click Policy Name, Department. What would be the best approcate to make it so when you click either completed consent or incomplete consent on the left table the right table filters to show the resepective selection of the document & department and then selected filter for consent status (complete / incomplete) . 



Community Support
Community Support

Hi @Tyker504 


Are you not wanting to filter the right table when you click on the left table? If I understand correctly, you can try the following:


1. select the left table first. Then select Format -> Edit interactions



2. select "None" in the upper right corner of the right table






Best Regards,
Yulia Xu


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Not quite. The left table is the main table that breaks down all policies with their completed %. When a use clicks into completed Consents or Incomplete Consents on the left hand side the right hand side filters down to show only the respective (incomplete / complete) status on the right. 



Clicking Left square will filter the right table to show those two squares.




but the tip you did provide above will help with that issue 😀

Hi @Tyker504 


Could you please provide me with more sample data so that I can better help you? How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show them as screenshots or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account. 


Best Regards,
Yulia Xu

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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


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.