Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
97 | |
97 | |
73 | |
72 |