Filter table based on matrix

[DSmith4]

Hi,

I have a matrix visual that is composed of vendor name and sum of dollar amount. The matrix is filtered only to show items where the vendor balance is over $100K for items over 90 days old.

I have a table at the bottom of the screen with the underlying data but it has ALL data, not just the ones included in the 90+days & sum of 100K category.

How can I filter the all data table based on what is shown on the matrix so I only show undering data for the vendors that meet the criteria discussed above (vendor balance 100K for items over 90 days aged)?

Thanks

[v-chuncz-msft]

@DSmith4 

You may add an appropriate measure to Visual level filters.

[NikoMendez]

Hi,

If I understand what you need, you can try this

Measure =
CALCULATE (
SUM ( 'Table'[K$] );
FILTER (
'Table';
'Table'[item age] > 90
&& CALCULATE ( SUM ( 'Table'[K$] ) ) > 100
)
)

Hope it helps

[amitchandak]

To help you further I need pbix file. If possible please share a sample pbix file after removing sensitive information.Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...