DAX Distinct Count Measure

[gavs73]

Hi, would appreciate any help with this, I have a List of Users and Dates they logged on over the last few years, I want to create a meaure which counts the number of Distinct Users who have logged on in the last Calendar Month and the Last 12 Months depending on the Month selected in the Calendar Slicer. Is there a way to combine DISTINCT COUNT and a FILTER based on the calendar slivcer value ?


Distinct Users Month = Count of DISTINCT Users where Date is in the Current Month Selected.

Distinct Users Year = Count of DISTINCT Users where Date is in the Previous 12 Months to the Current Month Selected.

Thanks for your help in advance.



Gav

 

[I_cant_read]

You might need to make use of a "calendar table" and filters in your measures.


=DISTINCTCOUNT(Filter())


Distinctcount

DISTINCTCOUNT function (DAX) - DAX

Learn more about: DISTINCTCOUNT

docs.microsoft.com

Filter

FILTER function (DAX) - DAX

Learn more about: FILTER

docs.microsoft.com

Sameperiodlast year

SAMEPERIODLASTYEAR function (DAX) - DAX

Learn more about: SAMEPERIODLASTYEAR

docs.microsoft.com

Just a rough idea tho.