Forum Discussion

sakamotothais's avatar
sakamotothais
Icon for Helper III rankHelper III
9 years ago

Filter and AllExcept is not a working

Dear Team,

 

I am trying to calculate count rows, that should fetch all record count except the filter in two columns. However this seems to be not working on power BI desktop.

 

I am getting same value though I change in the values in the columns mentioned in the all except clause).

 

Medida Running Total Segments by hour = CALCULATE(Sum(Consulta1[Revenue]),Filter(ALLEXCEPT(Consulta1,Consulta1[BookingDate]),'Consulta1'[BkHour]<=Max('Consulta1'[BkHour])))

 

I selected cancel code value, however no change in the value.

 

Please help.

 

Thanks!

 

Sakamoto

1 Reply

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi sakamotothais,

    You create Running Total Segments when BookingDate is same right? If it is, I try to reprodcue using the following sample data.



    I create a measure like yours, it works fine.

    Running Total for each Year = CALCULATE(SUM(Table1[sale]),FILTER(ALLEXCEPT(Table1,Table1[Year]),Table1[month]<=MAX(Table1[month])))



    Create a table visual to display the result, please see the following screenshot.



    Could you please post your sample data for further analysis?

    Best Regards,
    Angelia