Count duplicate ID

[Sir_night]

Hi

Need to be a able to count the number of customer orders  and be able to filter by order date wich updates the count of customer orders. 

Customer ID	Order ID	Order Date	No Customer Orders
1	1	1/01/2017	2
1	2	3/01/2017	2
2	3	2/01/2017	1
3	4	5/01/2017	4
3	5	8/01/2017	4
3	6	9/01/2017	4
3	7	10/01/2017	4

With Date filter 08/01/2017 to 10/01/2017

Customer ID	Order ID	Order Date	No Customer Orders
3	5	8/01/2017	3
3	6	9/01/2017	3
3	7	10/01/2017	3

[Eric_Zhang · Accepted solution]

---

@Sir_night wrote:

Hi

Need to be a able to count the number of customer orders  and be able to filter by order date wich updates the count of customer orders. 

Customer ID	Order ID	Order Date	No Customer Orders
1	1	1/01/2017	2
1	2	3/01/2017	2
2	3	2/01/2017	1
3	4	5/01/2017	4
3	5	8/01/2017	4
3	6	9/01/2017	4
3	7	10/01/2017	4

With Date filter 08/01/2017 to 10/01/2017

Customer ID	Order ID	Order Date	No Customer Orders
3	5	8/01/2017	3
3	6	9/01/2017	3
3	7	10/01/2017	3

---

@Sir_night

You can try a measure as below.

No Customer Orders =
COUNTAX (
    FILTER (
        ALLSELECTED ( Table1 ),
        Table1[Customer ID] = MAX ( Table1[Customer ID] )
    ),
    Table1[Order ID]
)