cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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 Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,020)