cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Meena Member
Member

Need help with DAX for total Active clients at any time

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

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
amitchandak Super Contributor
Super Contributor

Re: Need help with DAX for total Active clients at any time

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.

View solution in original post

1 REPLY 1
amitchandak Super Contributor
Super Contributor

Re: Need help with DAX for total Active clients at any time

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.

View solution in original post

Helpful resources

Announcements
New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,771)