count distinct by month

[coollehavre]

Hi, i have a table like this : 

Id       Date           Count

1069  1/12/2018   1

1069  1/20/2018   0

...

1069  2/02/2018   1

TOTAL                   2

I would like to count each ID by month (DISTINCTCOUNT(Id) => it's ok i have a relation to a date Table.

BUT

i would like to create a measure to sum all the Id by month to have 2 on TOTAL, and in my case, he counts 1

How to resolve ?

Thanks

[Zubair_Muhammad · Accepted solution]

@coollehavre

Please try this MEASURE

Measure =
IF (
    HASONEFILTER ( Table1[Date].[Month] ),
    CALCULATE ( DISTINCTCOUNT ( Table1[Id] ) ),
    SUMX (
        ALLSELECTED ( Table1[Date].[Month] ),
        CALCULATE ( DISTINCTCOUNT ( Table1[Id] ) )
    )
)

[Zubair_Muhammad]

@coollehavre

Sample file attached as well