Forum Discussion
Filter table based on matrix
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
3 Replies
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-trend/ba-p/882970Hi,
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
