Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi looking to find an easy way to turn the table below into a cumulative table
Solved! Go to Solution.
hi, @Anonymous
You could just use formula like below to create a cumulative measure
Cumulative =
CALCULATE (
expression,
FILTER ( ALL ( YourTable ), YourTable[Bucket] <= MAX ( YourTable[Bucket] ) )
)
here are related blogs for you refer to:
https://www.daxpatterns.com/cumulative-total/
https://javierguillen.wordpress.com/2012/11/28/running-total-techniques-in-dax/
Best Regards,
Lin
i am looking to find a way to make this table cumulative so on the left side we have number of users and the bottom we have number of days. I want a way to say 0 = 22% rather than 1=3% it should be 1=25%
Take a look at the cumulative total pattern.
https://www.daxpatterns.com/cumulative-total/
Cumulative Quantity := CALCULATE ( SUM ( Transactions[Quantity] ), FILTER ( ALL ( 'Date'[Date] ), 'Date'[Date] <= MAX ( 'Date'[Date] ) ) )
hi, @Anonymous
You could just use formula like below to create a cumulative measure
Cumulative =
CALCULATE (
expression,
FILTER ( ALL ( YourTable ), YourTable[Bucket] <= MAX ( YourTable[Bucket] ) )
)
here are related blogs for you refer to:
https://www.daxpatterns.com/cumulative-total/
https://javierguillen.wordpress.com/2012/11/28/running-total-techniques-in-dax/
Best Regards,
Lin
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |