Hi,
I have a lists of transports. The list contains for each transport the source (warehouse), the desutination (clientID) and the shipment date.
Ultimately, I want to show in a 100% bar chart the share of clients that are being delivered daily, up to 4 times per week, up to x times per week etc..
So I started by writing a measure that counts the unique clientIDs where the number of shipments is >=250 (250 working days).
1st Measure (working fine): Deliveries = DISTINCTCOUNT(Data[Deliverydate])
2nd Measure (not working): NbrDailyClients = COUNTAX(Data[ClientID];[Deliveries]>=250)
Thank you for your advices!
I have a lists of transports. The list contains for each transport the source (warehouse), the desutination (clientID) and the shipment date.
Ultimately, I want to show in a 100% bar chart the share of clients that are being delivered daily, up to 4 times per week, up to x times per week etc..
So I started by writing a measure that counts the unique clientIDs where the number of shipments is >=250 (250 working days).
1st Measure (working fine): Deliveries = DISTINCTCOUNT(Data[Deliverydate])
2nd Measure (not working): NbrDailyClients = COUNTAX(Data[ClientID];[Deliveries]>=250)
Thank you for your advices!