Filter and AllExcept is not a working

[sakamotothais]

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

[v-huizhn-msft]

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