Add number of invoices by date

[jdelacrettaz]

hello, I have a table where all the sales are per day, in a column I have the invoice numbers that are repeated depending on how many items I buy. My question is this, I want to make a measure where you tell me the amount of sales that were made per day, I pass an image. If someone can help me I would be so thankful

invoice number	date
1111	28/09/2019
1111	28/09/2019
1112	28/09/2019
1113	01/10/2019
1114	02/10/2019
1114	02/10/2019
Result
	quantity sold
28/09/2019	3
01/10/2019	1
02/10/2019	1

[Greg_Deckler · Accepted solution]

@jdelacrettaz - You could use the built-in Count (Distinct) aggregation. If you really want a measure, then you should be able to do this:

Measure = COUNTROWS(DISTINCT('Table'[invoice number]))