Distinct count by date

---

pablors wrote:

Hi everyone, 

 

First of all, sorry for my english, i´m not used to write in this language.

 

I have a problem with a measure. I don´t even know if i should use a measure or a calculated column. 

 

I have a table which look like this, it´s related to phone numbers which result can be a sale or not:

 

PHONE                       DATE                 SALE

600001                   01/09/2017              Y

600001                   02/09/2017              N

600002                   02/09/2017              N

600003                   03/09/2017              N

600003                   04/09/2017              Y

600004                   04/09/2017              Y

 

What i want is to paint that on a visual without making changes on the table itself. But i only want unique values by the first date. It would lok like this:

 

DATE                   SALE

01/09/2017            1

02/09/2017            0

03/09/2017            1

04/09/2017            1

 

Thanks in advange, and sorry again.

---

pablors

You can try to create a measure as below.

Measure =
VAR sales =
    CALCULATE (
        DISTINCTCOUNT ( Table1[PHONE] ),
        FILTER ( Table1, Table1[SALE] = "Y" )
    )
RETURN
    IF ( ISBLANK ( sales ), 0, sales )