Forum Discussion
Running Total
Hi NewbieJono ,
I’d like to acknowledge the valuable input provided by sergej_og . His initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue.
In my investigation, I took the following steps:
I create a table as you mentioned.
Then I create a new measure and a calculated column.
Measure = CALCULATE ( SUM ( 'Table'[Vol] ), FILTER ( ALL ( 'Table' ), 'Table'[Days] <= MAX ( 'Table'[Days] ) ) )Column = SUM('Table'[Vol])Finally I create another measure and get what you want.
Measure 2 = DIVIDE('Table'[Measure],MAX('Table'[Column]))Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Pls try to get a measure which is ignoring provided filter context. In your screenshot I can identify your given categories (0-1 Days, 1-2 Days etc.).
Try to create a measure with ALL()...copy your "Volume Measure" and adjust with ALL(your Table data comes from).
So that you will get 1,257,649 in every row you have in your visual.
Play a bit around with that. You know your model best.
After you have your measure with a Total in every row you can just divide one by other.
Regards
Thank you, i managed to get it going with a bit of messing (like you said!) The measures have resulted some of the days with no data being shown. Is there a method to stop this in the dax or do I just filter out the blanks.
The measure that is triggering all empty rows to show is
Measure =
CALCULATE (
[Volume Measure],
FILTER ( ALL ( 'Table' ), 'Table'[Keying To Output Day] <= MAX ( 'Table'[Keying To Output Day] ) )
)
New output but i don't want to show vol that are blank
Maybe you can try with a IF-Statement.
Like this...
IF( [Volume measure] <> BLANK(),
[Tes6])Thanks Everyone for your help with this