Need help with DAX for total Active clients at any time

[Anonymous]

Hi Community,

I am struggling to find total Active clients at any time. I think what I want to see is cumulative sum of active clients till a given time.

Attached is my PBI sample file:  https://1drv.ms/u/s!Ag919_pO_UKrfRMyC_hju4xy4oc?e=noOgqs

The following dax doesnt give right result:

Active Clients = CALCULATE(count(Data[internalid]),filter(Data,Data[statustext] = "Active" && Data[created]<= max(Data[created])))

Please suggest.

Many thanks in advance,

Meena

[amitchandak · Accepted solution]

Try this

Active Clients = CALCULATE(count(Data[internalid]),filter(all(Data),Data[statustext] = "Active" && Data[created]<= max(Datedim[Date])))

pbix

https://www.dropbox.com/s/zdyjw3ltg7usg57/Active%20clients.pbix?dl=0

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.