Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Sohan
Helper III
Helper III

DAX for checking if ID is same

‎12-07-2022 02:29 AM

I have two tables: FactAppointment and FactSales. These tables have true/false columns FactAppointment[NewPatient] and FactSales[FirstSale]. Both tables also contain the column "UserID".

I want a calculated column in FactSales which states:
IF FactAppointment[NewPatient] = TRUE AND FactSales[FirstSale] = TRUE AND UserID is the same, then TRUE, else FALSE.

 

How can I write this?

Labels:
Message 1 of 5
1,127 Views
0
4 REPLIES 4
Tahreem24
Super User
Super User

‎12-07-2022 03:11 AM

@Sohan Try something like below as per your columns and table names

 = IF(FactAppointment[NewPatient]= TRUE AND FactSales[FirstSale] = TRUE AND FactAppointment[UserID]  = FactSales[User ID], True(),False())

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
Message 4 of 5
1,079 Views
0
Sohan
Helper III
Helper III
In response to Tahreem24

‎12-07-2022 03:16 AM

It says the syntaxis is incorrect. I suspect because there's no direct relation between FactAppointment and FactSales.

Message 5 of 5
1,073 Views
0
JorgePinho
Solution Sage
Solution Sage

‎12-07-2022 02:42 AM

Hello @Sohan !

Are the tables connected? 

Message 2 of 5
1,120 Views
0
Sohan
Helper III
Helper III
In response to JorgePinho

‎12-07-2022 02:57 AM

Yes, indirectly through other tables.

Message 3 of 5
1,094 Views
0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

View All