Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Well-Mart
New Member

Filter a table based on a temporary filtered other table

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]

 

WellMart_0-1713807617247.png

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

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] ) )
)

View solution in original post

2 REPLIES 2
tamerj1
Super User
Super User

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. 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors