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.
Hello Everyone,
I´m trying to get to count (distinct) how many times a Pallet Code was used multiple times for different deliveries within the same shipment Number --> A shipment can contain multiple Deliveries and the deliveries can have the same pallet code
Shipment Number | Delivery Number | Pallet Code | DISTINCTCOUNT Expected Output |
234 | 8 | 555 | 3 |
234 | 6 | 555 | 3 |
234 | 5 | 555 | 3 |
The example above contains one Shipment Number (555) with multiple deverlies where they all used the same Pallet Code, menaing the pallet code has been used 3 times within the same Shipment and multiple deliveries
I used this, but seems not working well:
Countv1 = COUNTROWS(FILTER(SSCC, SSCC[Shipment Number] = EARLIER(SSCC[Shipment Number]) && SSCC[Pallet Code] = EARLIER(SSCC[Pallet Code])))
Many thanks!
Solved! Go to Solution.
@manuelfigueirat , if this is a column, this seems fine
countx(filter( SSCC, SSCC[Shipment Number] = EARLIER(SSCC[Shipment Number]) && SSCC[Pallet Code] = EARLIER(SSCC[Pallet Code])),[Shipment Number])
for measure
countx(filter(allselected( SSCC), SSCC[Shipment Number] = MAX(SSCC[Shipment Number]) && SSCC[Pallet Code] = MAX(SSCC[Pallet Code])),[Shipment Number])
@manuelfigueirat , if this is a column, this seems fine
countx(filter( SSCC, SSCC[Shipment Number] = EARLIER(SSCC[Shipment Number]) && SSCC[Pallet Code] = EARLIER(SSCC[Pallet Code])),[Shipment Number])
for measure
countx(filter(allselected( SSCC), SSCC[Shipment Number] = MAX(SSCC[Shipment Number]) && SSCC[Pallet Code] = MAX(SSCC[Pallet Code])),[Shipment Number])
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |