ALL isn't working as expected

[juju63]

hello,

I've created a report using direct query and created a conditional column "#mesure RTD"  :

#Mesure RTD = UPPER(IF(CES_LAST[MINIMUM TREAD DEPTH]<CES_LAST[ORIGINAL TREAD DEPTH] && not isblank(CES_LAST[RTD Average]) && CES_LAST[ORIGINAL TREAD DEPTH]<>CES_LAST[RTD Average],"Measurement","No exam"))

I use it in the panel to filter all the report pages.

I've got a mesure in one page of the report that should not be affected by this filter

comptes AG.20 tracteurs HP = CALCULATE(DISTINCTCOUNT(CES_LAST[#clé_unique]), CES_LAST[TREAD PATTERN]="MACHXBIB"||CES_LAST[TREAD PATTERN]="AXIOBIB",...,ALL(CES_LAST[Tire Followed]),ALL(CES_LAST[#Mesure RTD]), ALL(CES_LAST[VehicleClassCategoryEnum]),ALL(CES_LAST[country 2])

what I was expecting is that the measure stills the same, but trying to change the filter, the value evolves ...

what did I made the wrong way ?

[v-mengmli-msft]

Hi @juju63 ,

Until I saw the pbix file, it was hard for me to see what was causing the problem. Could you please show some sample data and link to pbix file?

Best regards,

Mengmeng Li

[juju63]

unfortunately, due to confidential rules, I can't share the report : it's a directquery then you won't have access to the data

[SamWiseOwl]

HI @juju63 

Couple of things to check

•     Are there any other filters on the card (hover over the funnel)
•     Is there another column in the table that could cause the same filter (create a table visual and remove the columns one by one)
•    Do you sort this column by another column (month sorting month name) need to remove both

You could also consider using AllExcept which lets you remove all filters but keep the ones you specifiy.

AllExcept(CES_LAST, table or column filters to keep)

[juju63]

hello SamWiseOwl, and thank you for your help.

. there's no other specific filter on the card

. no other column that I could use instead

. no specific sorting

filters on the page are more powerfull than any dax fonction (all, allexcept, ...)

I tried the removefilter fonction but it's not even better ...

after more investigations, it could be linked with the auto exists in powerbi

[juju63 · Accepted solution]

finally, I'm done !! a better use of removefilters and now everything is ok comptes AG.20 tracteurs HP = CALCULATE( DISTINCTCOUNT(CES_LAST[#clé_unique]), ALL(CES_LAST[#Mesure RTD], CES_LAST[VehicleClassCategoryEnum], CES_LAST[VehicleClassName]), CES_LAST[TREAD PATTERN] IN {"MACHXBIB", "AXIOBIB", "TM900 HP", "TM1000 PT", "TM1000 HP", "TM1000 PROGRESSIVE TRACTION", "TM 1000 PT", "VT-TRACTOR", "VX-TRACTOR", "TRACTORMASTER", "VF TRACTORMASTER", "TRAXION XXL", "OPTITRAC DT824", "OPTITRAC R+", "OPTITRAC", "OPTITRAC DT812", "OPTITRAC DT806"} && CES_LAST[TYRE STATUS] = "SCRAP" && CES_LAST[EVENT DATE]>DATE(2024,1,1), Zone[Zone] IN {"ECA","EUN","EUS"},REMOVEFILTERS() )