DAX PB DISTINCTCOUNT with Criteria

[FanofExcel18]

I'm trying to calculate on a weekly basis, the total Distinct Amounts. Example: Invoice 123456 shows 3 times, but only want to show 1

Invoice	Amount	Date
123456​	1​	1-Mar​
123457​	0​	1-Mar​
123458​	0​	1-Mar​
123459​	0​	1-Mar​
123456​	1​	2-Mar​
123457​	1​	2-Mar​
123458​	1​	2-Mar​
123459​	0​	2-Mar​
123456​	1​	3-Mar​
123457​	0​	3-Mar​
123458​	0​	3-Mar​
123459​	0​	3-Mar​

 

[C Moore]

Do you have weeks setup somewhere? If so a table visual (filtered for week) with a column for week, invoice, and amount as distinct count would do it. Or a matrix visual with weeks then invoice as rows with distinct count amounts as values.