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

Tyker504_0-1718814152055.png

 

3 REPLIES 3
v-xuxinyi-msft
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

vxuxinyimsft_1-1718850059269.png

 

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

vxuxinyimsft_2-1718850139188.png

 

Output:

vxuxinyimsft_3-1718850233400.png

 

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.

Tyker504_0-1718893726872.png

 

 

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

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.