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