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])))
Many thanks in advance,
Go to Solution.
Active Clients = CALCULATE(count(Data[internalid]),filter(all(Data),Data[statustext] = "Active" && Data[created]<= max(Datedim[Date])))
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
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Find out where you can attend!