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.
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.
my report filters (all filter select defualt to All)
CAL_YEAR slicer base on D_Date[CAL_YEAR]
I created 2 measures:
The result of this calculation gave me 121 protocol. However, when I run the code below in SQL tool, I got 431 protocol.
Do you see any issue with my measures (syntax or structure)? Your help is greatly appreciated.
Thank you in advance
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |