Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
Solved! Go to 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]))
@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]))
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |