Selecting aggregate column on one table sets filter on different table

[Tyker504]

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) . 

[Anonymous]

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

Output:

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.

[Tyker504]

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 😀

[Anonymous]

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