Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
You may add an appropriate measure to Visual level filters.
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
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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |