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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
bngo25
Frequent Visitor

USERELATIONSHIP and Or Clause in Measure

Hello Expert,

here is my model.  Trials connect to d_date on On_Trial_Date (active) and Protocol_Open_to_Accrual_DT (inactive).  I'm trying to count distinct protocol base on Protocol_Open_to_Accrual_DT.  

bngo25_0-1673974808341.png

 

my report filters (all filter select defualt to All)

bngo25_1-1673974894829.png

CAL_YEAR slicer base on D_Date[CAL_YEAR]

I created 2 measures:

bngo25_2-1673974984875.png

 

bngo25_3-1673975049436.png

The result of this calculation gave me 121 protocol.  However, when I run the code below in SQL tool, I got 431 protocol.

bngo25_4-1673975202118.png

Do you see any issue with my measures (syntax or structure)?  Your help is greatly appreciated.

 

Thank you in advance

0 REPLIES 0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.