Forum Discussion
gumis_rulez
Helper I
Helper ISUMMARIZE giving wrong value
Hi,
When I count distinct orderID's the result is 4924.
When I use SUMMARIZE to create new table:
Summary = SUMMARIZE(Orders, Orders[CustomerName], "Total Orders", DISTINCTCOUNT(Orders[OrderId]))
I receive a table, which sum of Total orders gives 4941.
What is wrong?
Nothing special, some OrderIds correpsond to multiple customers,
1 Reply
- ThxAlot
Super User
Nothing special, some OrderIds correpsond to multiple customers,