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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

Filtering data using value from another colums

Hi All,
 
Our project management system this contains projects that have a parent and child relationship
 
Master Project Code BOS-1234 / Segment Project Code > MUB-5678
 
sample 
 
Project Number
Project Name
Campaign 
Segment Project Code
Value
 
BOS-1234
Project 1
Campaign 1 
MUB-5678
$1000 
 << Filter this
MUB-5678
Child Project 1
Campaign 1 
 
$2000
<< Also shows this
 
I would like to create a filter method where I can filter the project number BOS-1234 this also returns data for the segment project number MUB-5678. 
 
Can anyone help ? 

 

1 REPLY 1
v-chuncz-msft
Community Support
Community Support

@Anonymous,

 

You may take a good look at the article below.

http://www.daxpatterns.com/parent-child-hierarchies/

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.