Distinct count by date

[pablors]

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.

[Eric_Zhang]

---

@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 )

[pablors · Accepted solution]

Thank you so much Eric, 

I found a simple solution after thinking calmly about the problem. 

I made a custom column and put it as the X axis in my chart. 

1era = CALCULATE(FIRSTDATE('Table1'[Date]); ALLEXCEPT('Table1'[Phone]))

Then I includes de registered phones and which are sales, and the ratio of succes

Thanks!