Forum Discussion
ALL isn't working as expected
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() )
Super UserHI 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)
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
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() )