Count first occurrence by selected filters date

[jarenasv]

Hi, I am working with data visualization and trying not to count duplicates and not seeing how to accomplish, the objective is to count only the first ocurrence, using as a filter periods of dates, years, months etc and/or filtering the other related tables.

The objective is to work only with data that is displayed dynamically according to the selected filters.

Below is some made up data that should help explain issue:

Another user from the community helped me with the issue of duplicity (v-lili6-msft ), but not work if I apply a filter to Date column or other filter of the related tables.

Measure used to count the first occurrence.

result = CALCULATE(COUNTROWS(Query),FILTER(Query,Query[DATE]=CALCULATE(MIN(Query[DATE]),ALLEXCEPT(Query,Query[ID]))))+0

In this measure, I would like to include the respective filters mentioned above. I have used the allselected function but it does not work.

Actually:

Issue when using the date filter:

Expected result using filters:

I emphasize that I can not occupy calculated columns is too much information and applying only the filters could reduce the processing times in Analysis Services 2014.

Thank You.

[v-chuncz-msft · Accepted solution]

@jarenasv ,

You may try the following measure.

Measure =
SUMX (
    VALUES ( Query[ID] ),
    CALCULATE (
        VAR d =
            MIN ( Query[DATE] )
        RETURN
            IF ( d = CALCULATE ( MIN ( Query[DATE] ), ALLSELECTED ( Query[DATE] ) ), 1, 0 )
    )
)