Forum Discussion
ACCUMULATED DAX
Hi all,
I'm building a Customer Report and got a problem. Hope someone can help me to solve it :(
I want to track Customer's Health. Here is my user table struture:
Col1: user's email
Col2: user's created date
Col3: user's company name
Col4: user's status (O is active, -1 is inactive)
Please kindly take a look this example
I have 01 Customer:
- Company A
- At the moment, Company A has 10 active users
- 5 users had created in Week 31
- 3 more users had created in Week 32
- 2 more users had created in Week 33
I want to know how many created users of company A.
The correct result I want to see are:
W31: 5 created users
W32: 8 created users
W33: 10 created users
But when I'm using this below DAX
= CALCULATE(DISTINCTCOUNT('Users Table'[email]),FILTER('Users Table','Users Table'[status] <> -1))
The incorrect results ares:
Week 31: 10 created user
Week 32: 10 created user
Week 33: 10 created user
(In the future, if the company A create 5 more users, the results will look like
Week 31: 15 created user
Week 32: 15 created user
Week 33: 15 created user
Week 34: 15 created user)
Please kindly help me in this issue. Thanks in advance.
3 Replies
Hi there,
What you are looking for is the "running Total"
You can easiliy create this whith a Quick measure in PowerBI.
Have a look here: https://docs.microsoft.com/en-us/power-bi/desktop-quick-measures
Good luck!Robbe
Hi Robble VL, thanks for your quick response.
Please kindly take a look at these pictures in below
When I'm not using Running total Formula, the result will look like:
When I'm adding Running Total DAX,Active Members running total in Created Date =CALCULATE([Active Members],FILTER(ALLSELECTED('base Users'[Created Date]),ISONORAFTER('base Users'[Created Date], MAX('base Users'[Created Date]), DESC)))The result isAs you can see, the date 7/10/2019 appeared 12 times, but I just want to see it 1 time. Like this:7/10/2019 127/11/2019 157/17/2019 167/23/2019 177/26/2019 18Please kindly help me :(Anonymous ,
So [Active Members] is a measure right? Could you show that measure? If possible, could you also share the sample data?
Regards,
Jimmy Tao
