Forum Discussion

Thyago_Rezende's avatar
Thyago_Rezende
Icon for Resolver I rankResolver I
9 years ago
Solved

Distinct Count over entire Calendar table

I need to retrieve the DISTINCTCOUNT customers only for the last buy it. But, my measure return the DISTINCT COUNT for every month. The picture below shows the behavior.       The measure s...
  • Thyago_Rezende's avatar
    Thyago_Rezende
    9 years ago

    Hi Anonymous, Greg_Deckler

     

    I got it. The prior formula was correct. The filter context applied on Customer Table have changed the results. But, I didn´t understand that behavior it.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

HI Thyago_Rezende,

 

You can use 'lastdate','all' functions to achieve your requirement.

Measure = CALCULATE(DISTINCTCOUNT('Table'[Client]),FILTER(ALL('Table'),[Date]=LASTDATE(ALL('Table'[Date]))))

Regards,

Xiaoxin Sheng

Thyago_Rezende's avatar
Thyago_Rezende
Icon for Resolver I rankResolver I
9 years ago

Hi Anonymous, Greg_Deckler

 

I got it. The prior formula was correct. The filter context applied on Customer Table have changed the results. But, I didn´t understand that behavior it.