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.
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])
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |