topic How to count distinct ids on max date in DAX Commands and Tips

How to count distinct ids on max date

Sameer5858 — Tue, 05 Sep 2023 17:15:13 GMT

How to calculate count distinct values based on max date column. I need count of all distinct id whoes date is max

Re: How to count distinct ids on max date

AnthonyGenovese — Tue, 05 Sep 2023 17:29:51 GMT

I would do something like this

Var maxDate = Max('YourFactTable'[DateColumn])
var result = calculate( DISTINCTCOUNT('YourFactTable'[IDColumn]), 'YourFactTable'[DateColumn]=maxDate)
return result
If this post was helpful, please kudos or accept the answer as a solution.
~ Anthony Genovese
Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!

Re: How to count distinct ids on max date

v-zhangti — Thu, 07 Sep 2023 07:34:07 GMT

Hi, Sameer5858

You can try the following methods.

Sample data:

Measure:

Count = Var _maxdate=CALCULATE(MAX('Table'[Date]),ALL('Table')) Return CALCULATE(DISTINCTCOUNT('Table'[ID]),FILTER(ALL('Table'),[Date]=_maxdate))

Is this the result you expect? If not, please provide some of the example data and desired results.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.