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.
I have 2 tables.
The first table will be filtered by date using a slicer. This will return a list of invoice numbers.
I then would like to filter the second table by those invoice numbers that were returned in the first table.
Thank You
Solved! Go to Solution.
Hi @bgerew,
Based on my test, you should be able to use the formula below to create a measure, then use the measure to apply a visual level filter(Measure is great than 0) to filter the second table by selected value in first table.
Measure = SUMX ( Table1, IF ( CONTAINS ( Table1, Table1[Invoice Number], FIRSTNONBLANK ( Table2[Invoice Number], 1 ) ), 1, 0 ) )
Here is the sample pbix file for your reference.
Regards
Hi @bgerew,
Based on my test, you should be able to use the formula below to create a measure, then use the measure to apply a visual level filter(Measure is great than 0) to filter the second table by selected value in first table.
Measure = SUMX ( Table1, IF ( CONTAINS ( Table1, Table1[Invoice Number], FIRSTNONBLANK ( Table2[Invoice Number], 1 ) ), 1, 0 ) )
Here is the sample pbix file for your reference.
Regards
I'm a touch confused - is it possible that your data set has an invoice number more than once that can have different dates inside and outside of your slicer? I'd have thought that they should be unique, and the first slicer should, assuming there's some sort of relevant relationship, that the second table would be filtered in the way you want by default?
the invoice number can not be a managed relationship as it is a many to many relationship.
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |