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() )
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() )