Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello, everyone!
I need some help filtering tables that are not directly related.
I have this reference TABLE A - called Items. All my items are there, and the "key" is the Item Number(ArtNr);
Another TABLE B - called Orders, the "key" is also ItemNumber, and I have a visual Table to show me how many pieces per Order Number (OrderNr), based on each Item Number;
Finally, I have a third TABLE C - called Purchase (orders); the key also is ItemNumber as well, but it shows how many Purchase Order Numbers (BestNr) for each Item Number;
The problem is when I filter an Order Number (OrderNr) in [B] that has multiple Item Numbers (ArtNr), I wish it could filter the table [C] by the same Item Numbers (ArtNr) that are shown in table [B]; the Order Number is a slicer for the table [B]
Solved! Go to Solution.
Hi @Well-Mart
place the following measure in the filter pane of the prachse table visual, select "is not blank" then apply the filter
FilterMeasure =
CALCULATE (
COUNTROWS ( Purchase ),
KEEPFILTERS ( TREATAS ( VALUES ( Orders[AtNr] ), Purchase[ArtNr] ) )
)
Hi @Well-Mart
place the following measure in the filter pane of the prachse table visual, select "is not blank" then apply the filter
FilterMeasure =
CALCULATE (
COUNTROWS ( Purchase ),
KEEPFILTERS ( TREATAS ( VALUES ( Orders[AtNr] ), Purchase[ArtNr] ) )
)
Thank you, @tamerj1 ! It is working; the measure is counting when the Item in Purchase appears in the Orders table, then I filtered the Purchase table for not blank, and it filtered.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
8 | |
8 |
User | Count |
---|---|
13 | |
12 | |
11 | |
10 | |
8 |