Forum Discussion
Tkanchaveli
5 years agoRegular Visitor
Counting Only Duplicate Values That Appear Within Date Range
Hello, I have a Table that shows Sales done to Customers. One customer can purchase two product in a span of time. The Products are also sold at different Retailers. Order ID Customer ID...
- 5 years ago
Tkanchaveli , Try a measure like this
countx(filter(Summarize(Table, Table[Company], Table[Customer ID], "_1", count(Table[Order ID])),[_1] >1),[_1])
Tkanchaveli
5 years agoRegular Visitor
I added sumx and i think it worked, thanks.