Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi Experts , I have Order Number with Status as 1 and 0 , Few Order can have status as 0 or 1 both ,
I need to get the distinct Count of Order Number where Order is only 1
For below tables, I need Output as 2 , Since one Order-1 has both 0 and 1 and it should not be considered for Disctinct count
Hi,Thanks for the Quick Reply, But i see that code does not Check if Only FLAG=1 Order are considered, I do not want to pick order where Flag=0 has appeared.
It would fail in below scenario.
Still the Expected O/P is Distinct Count Should be 2
I tired below code which helped
Check out the November 2025 Fabric update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!