Forum Discussion

juju63's avatar
juju63
Regular Visitor
1 year ago
Solved

ALL isn't working as expected

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 ?

Need Help
  • juju63's avatar
    juju63
    1 year ago

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

5 Replies

  • SamWiseOwl's avatar
    SamWiseOwl
    Icon for Super User rankSuper User
    1 year ago

    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's avatar
      juju63
      Regular Visitor
      1 year ago

      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's avatar
        juju63
        Regular Visitor
        1 year ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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's avatar
      juju63
      Regular Visitor
      1 year ago

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