Forum Discussion

Tkanchaveli's avatar
Tkanchaveli
Regular Visitor
5 years ago
Solved

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...
Need Help
  • amitchandak's avatar
    amitchandak
    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])

amitchandak's avatar
amitchandak
Super User
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's avatar
Tkanchaveli
Regular Visitor
5 years ago

sadly it didn't work. i want to count the number of times each duplicate appears also. i think your formula only counts how many duplicates there are.

 

I like this part of the function as it counts what i want in a table:

filter(Summarize(Table, Table[Company], Table[Customer ID], "_1", count(Table[Order ID])),[_1] >1),[_1])

 

but i think  adding countx isn't working how i want it to work. i want to take the values the above function is giving me, but i want them to be filtered in date range and used in a vizualization