Forum Discussion

jthomson's avatar
jthomson
Solution Sage
7 years ago
Solved

Cumulative sum issues

Hi,   Data is as below:   QB Name Picks Thrown Tom Brady 0 Tom Brady 0 Tom Brady 1 Tom Brady 2 Tom Brady 4 Tom Brady 3 Tom Brady 1 Tom Brady 3 Tom Brady 2 ...
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    7 years ago

    HI jthomson - 

     

    I was able to get it to work by doing the following:

     

    Create a new table for all of the values in "Picks Thrown"

    IntNums = VALUES(Ints[Picks Thrown])

    Join to the Interceptions table

     

     

    Modified the measure to filter on IntNums table

     

    Games played with n or less picks =
CALCULATE (
    [Games Played],
    FILTER (
        ALLSELECTED ( IntNums ),
        IntNums[Picks Thrown] <= MAX ( IntNums[Picks Thrown] )
    )
)

    Use IntNums as the axis for the bar/line chart (and for the rows on the tables)

     

     

    Hope this helps

    David

dedelman_clng's avatar
dedelman_clng
Community Champion
7 years ago

HI jthomson - 

 

I was able to get it to work by doing the following:

 

Create a new table for all of the values in "Picks Thrown"

IntNums = VALUES(Ints[Picks Thrown])

Join to the Interceptions table

 

 

Modified the measure to filter on IntNums table

 

Games played with n or less picks =
CALCULATE (
    [Games Played],
    FILTER (
        ALLSELECTED ( IntNums ),
        IntNums[Picks Thrown] <= MAX ( IntNums[Picks Thrown] )
    )
)

Use IntNums as the axis for the bar/line chart (and for the rows on the tables)

 

 

Hope this helps

David

  • jthomson's avatar
    jthomson
    Solution Sage
    7 years ago

    Cheers, tweaked it a bit to use generateseries between 0 and the max value of the data, but the concept of using a separate table as the axis is working fine