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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
JJha75
Frequent Visitor

Power BI DAX help

Hi Community,
I am having difficulties in dax calculation. I hope you guys will help me, maybe it is very simple for some of you. Below is the scenario.
I have 3 tables, date table and two tables with project ID. there is relationship in date table and project B table, and table A has master list of projects that is related with Table B using project id.
I want to get list of missing projects name from table B when comparing to master project list of table A. Now, I want to get a list of projects id based on date filtered in date slicer of  date table where table B project doesn't appear in table A Project. I want to use DAX measure or column for this solution. 
Thanks for the help.
Jag
PBI issues.JPG

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@JJha75 , Use this measure along with Project from Table A in a visual

 

countrows(except(values(Table1[Project]), distinct(Table2[project]) ) )

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@JJha75 , Use this measure along with Project from Table A in a visual

 

countrows(except(values(Table1[Project]), distinct(Table2[project]) ) )

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors