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.

Anonymous's avatar
Anonymous
Not applicable
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

Thanks for your help. howver this does not seem to work.  It may be because my vol column is a measure that returns a result

  • sergej_og's avatar
    sergej_og
    Super User
    2 years ago

    Can you provide this result (from your measure) as a calculated column in your model?
    Could make sense to do so.
    But you know your model best.

    Regards

    • NewbieJono's avatar
      NewbieJono
      Post Partisan
      2 years ago

      My volume measure  is:

       

      Volume Measure = 
CALCULATE (
    SUM ( 'FACT- Output'[Total] )
        + CALCULATE (
            SUM ( 'FACT - Process Volumes'[Volume] ),
            'FACT - Process Volumes'[NEW Days Range] = "0-1 Days"
        )
)

       

      with your code i have managed to get the running total. i just now need to divide each row by the total

       

      • sergej_og's avatar
        sergej_og
        Super User
        2 years ago

        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