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])

Tkanchaveli's avatar
Tkanchaveli
Regular Visitor
5 years ago

If i were to use sum in a vizualisation using 

filter(Summarize(Table, Table[Company], Table[Customer ID], "_1", count(Table[Order ID])),[_1] >1),[_1]) filter, then i'd get the report i need