Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I'm looking to count all partial deliveries.
To do this, I want to make a formula counting all ORDER_CODE with 2 or more different DELIVERYTODATE.
How do I go about this?
This is the formula I tried using:
Solved! Go to Solution.
@Anonymous , Try a new measure like
Countx( filter(summarize(TRANSPORT_ORDER, TRANSPORT_ORDER[ORDER_CODE],"_1",DISTINCTCOUNT( TRANSPORT_ORDER[DELIVERYTODATE]) ), [_1] >1), [ORDER_CODE])
@Anonymous , Try a new measure like
Countx( filter(summarize(TRANSPORT_ORDER, TRANSPORT_ORDER[ORDER_CODE],"_1",DISTINCTCOUNT( TRANSPORT_ORDER[DELIVERYTODATE]) ), [_1] >1), [ORDER_CODE])
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |