Forum Discussion

SamOvermars's avatar
SamOvermars
Icon for Helper I rankHelper 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
Icon for Resident Rockstar rankResident Rockstar
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))
SamOvermars's avatar
SamOvermars
Icon for Helper I rankHelper I
4 years ago

richbenmintz  Im not sure how Power BI is handeling this in the backend. but the measure is showing it like this now.

 

  • richbenmintz's avatar
    richbenmintz
    Icon for Resident Rockstar rankResident Rockstar
    4 years ago

    Hi SamOvermars ,

     

    Could you provide a sample pbix file and the expected outcome as a visual?