Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create a Table with Custom Cumulative total

Hi,   I have a RAW Table like this: RAW_Table Code Current_Phase AA1 Phase 1 AA2 Phase 3 AA3 Phase 2 AA4 Phase 5 BB1 Phase 6 BB2 Phase 6 CC1 Phase 4 CC2 Phase ...
Need Help
  • DataZoe's avatar
    DataZoe
    4 years ago

    Anonymous Another approach is also to create a table with all phrases for the current phrase, and join it. 

     

    Join on Current Phase (M-M relationship)

     

    Then you can just just All Phases and row count from main table.

     

     

PaulDBrown's avatar
PaulDBrown
Community Champion
4 years ago

See if this works for you:

Cumulative Phases =
CALCULATE (
    COUNTROWS ( 'Raw Table' ),
    FILTER (
        ALL ( 'Raw Table' ),
        'Raw Table'[Current_Phase] >= MAX ( 'Raw Table'[Current_Phase] )
    )
)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi PaulDBrown ,

     

    I got all the cumulative phases to 2:

     

     

    • PaulDBrown's avatar
      PaulDBrown
      Community Champion
      4 years ago

      What measure are you using? this is what I get:

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Paul,

     

    I solved the problem with DataZoe approach. I think my requirements weren't completely clear, so your solution wasn't satisfying my needs. But the DataZoe approach worked. Thanks!