Forum Discussion

SamOvermars's avatar
SamOvermars
Helper I
4 years ago
Solved

Filtering rolling total based on value in another column

Hello,  I have this sample table  Box# Item Category Date Produced Truck2 Requested Truck3 Requested B100 A Autos 2/1/2021 4 0 B100 B Home 2/5/2021 1 1 B200 A2 Home 2/...
Need Help
  • richbenmintz's avatar
    richbenmintz
    4 years ago

    Hi SamOvermars ,

     

    Maybe you should filter the data in the measure

    Measure = CALCULATE( COUNTROWS('table')
,FILTER( ALL( 'table'[Date Produced]), 'table'[Date Produced] <= MAX('table'[Date Produced]) && 'table'[Produced Truck2 Requested]<>0))
richbenmintz's avatar
richbenmintz
Resident Rockstar
4 years ago

Hi SamOvermars ,

 

Using your sample data and assuming you are looking to count the rows cummulatively, the following Measure should work

 

Measure = CALCULATE( COUNTROWS('table')
,FILTER( ALL( 'table'[Date Produced]), 'table'[Date Produced] <= MAX('table'[Date Produced])))

produces the following line chart

If you need a different outcome please include a more representative set of data and a screen cap of the desired result.

 

SamOvermars's avatar
SamOvermars
Helper I
4 years ago

Thank you richbenmintz  Almost!It worked but its not letting me filter the visual.

Is there any reason why the line chart looks like this after adding a filter to the visual where truck 2 is not 0