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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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
User | Count |
---|---|
15 | |
9 | |
8 | |
6 | |
5 |
User | Count |
---|---|
29 | |
18 | |
15 | |
7 | |
6 |