DAX REMOVEFILTERS and ALL not working on date column

[dpombal]

Hi all i am using may update  and a formula used to work in report similars is not working now.

My problem is very easy to explain I want to fix a calculation to get the average of distance FOR ALL DATES ( so I need to remove filter on this DATEF field, but if I add to the page a slicer, the measure changes, this was working in an old Report, I think It can be something of the new powerbi may 2023 update)

My problem is REMOVEFILTERS  is not working fo TableGPS[DATEF] column and also not working for TableGPS[DRILL]

version1

DISTANCE TOTAL AVERAGE MD = CALCULATE(
AVERAGE('TableGPS'[DISTANCE]),
      TableGPS[Type]="MD",
      TableGPS'[DURATION]>=70,
   REMOVEFILTERS(TableGPS[DATEF], TableGPS[DRILL])
)

version 2 with ALL also not working

DISTANCE TOTAL AVERAGE MD = CALCULATE(
     AVERAGE('TableGPS'[DISTANCE]),
    TableGPS[Type]="MD",
     TableGPS'[DURATION]>=70,
   ALL(TableGPS[DATEF], 'TableGPS'[DRILL])

)

Regards

[dpombal]

Please I need help this looks like a critical error on DAX  related 2 important functions

[dpombal]

I already know...for this date there are no rows for this criteria, but in prior versions REMOVEFILTERS worked OK and I could FIX the value I want , Please undertstand my requirement, I have other reports working with a similar formula

[dpombal]

Hi all here I share a link with the PBIX file to download, all trials are wrong.

REMOVEFILTERS and ALL are failing, looks like a bug.

Download sample file

https://1drv.ms/u/s!Am7buNMZi-gwg8hT4eo1bkHP975Egg?e=goyfU7 

Regards

[some_bih]

@Mahesh0016  when AVERAGE needs to be calculated properly, column with unique values should be populated in visual - insure this.

[Mahesh0016]

Hii @dpombal I hope this helps you!THANK YOU!!

version 2 with ALL also not working

DISTANCE TOTAL AVERAGE MD = CALCULATE(
     AVERAGE('TableGPS'[DISTANCE]),
    'TableGPS'[Type]="MD"&&
    'TableGPS'[DURATION]>=70,
   ALL('TableGPS'[DATEF],'TableGPS'[DRILL])

)

[dpombal]

this was not the fail..thanks

[Mahesh0016]

@dpombal Please share your ENDOUTPUT in table and dataset.

[dpombal]

I have uploaded sample PBIX file, thanks in advancehttps://1drv.ms/u/s!Am7buNMZi-gwg8hT4eo1bkHP975Egg?e=goyfU7 

[some_bih]

Hi @dpombal try ALLEXCEPT (TableGPS[DATEF], 'TableGPS'[DRILL])  and check you results. I hope this help

[dpombal]

I have uploaded PBIX sample FILE

https://1drv.ms/u/s!Am7buNMZi-gwg8hT4eo1bkHP975Egg?e=goyfU7 

[some_bih]

Hi @dpombal  try your measure 

DISTANCE TOTAL AVERAGE MD v1 

= CALCULATE(

     AVERAGE(TableGPS[DISTANCE]),

    TableGPS[Type]="MD",

    TableGPS[DURATION]>=70
)

[dpombal]

This measure is not valid for my example. I need to removefilters from 2 columns DATE and DRILL, and your measure doesn't removes these filters.

[some_bih]

Hi @dpombal for date 21.03.2023 there is not rows which are once from your filter argument of calculate:  

TableGPS[Type]="MD",
TableGPS'[DURATION]>=70,

Give as example which expected value you are looking for certain filters so we could try to create measure.

[dpombal]

No ALLEXCEPT does not work...in fact it makes opposite operation.

Why is failing ...REMOVEFILTERS...