How to Build a Stacked column chart by distinct count by category

[irfandbintang]

Hi Good Morning All, i want to ask about my case. So what i want to build is a stacked column chart, the axis is Location, legend is the delivery status (delay/not), value is total unique shipment(there are multiple shipment number).

What i want to ask is how i can calculate the distinctcount of shipment by Location? 1 Shipment number can be in multiple row & Location. For reference i give the snapshot of my dataset:

Would really appreciate if someone know the answer/formula. Thanks All 😁

[v-stephen-msft]

Hi @irfandbintang ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,
Stephen Tao

[v-stephen-msft · Accepted solution]

Hello @irfandbintang ,

You could try it that way.

Measure = CALCULATE(DISTINCTCOUNT('Table'[Shipment ]),ALLEXCEPT('Table','Table'[Location]))

Reference: ALLEXCEPT

DISTINCTCOUNT

Best regards

Stephen Tao

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[amitchandak]

@irfandbintang , not very clear. You can use location on axis and distinctcount(Table[Shipemnt])