Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
2 years ago
Solved

Running Total

Hello all, i have a measure which creates a volume. how can I use dax to create a % based on total.   e.g 0-1 would be top row / total 1-2 would be , total of top two rows / total 2-3 would be, ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

NewbieJono's avatar
NewbieJono
Post Partisan
2 years ago

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

 

sergej_og's avatar
sergej_og
Super User
2 years ago

Maybe you can try with a IF-Statement.
Like this...
IF( [Volume measure] <> BLANK(),
     [Tes6])

  • NewbieJono's avatar
    NewbieJono
    Post Partisan
    2 years ago

    Thanks Everyone for your help with this