Forum Discussion
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/...
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))
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
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 Im not sure how Power BI is handeling this in the backend. but the measure is showing it like this now.