The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 | |
13 | |
9 | |
6 | |
6 |
User | Count |
---|---|
29 | |
18 | |
13 | |
8 | |
5 |