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

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

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
Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

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.