Forum Discussion

smallfires0628's avatar
smallfires0628
Helper I
2 years ago
Solved

Measure not affected by Filter

I have a measure with the following code: Total Containers = sum('Booking List'[Containers]). It isn't affected by any filters I apply for the visuals, the amount stayed the same. 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi smallfires0628 

    You can use crossfilter() function.

    e.g The column between the tables to connect is named a.

    Total Containers =
CALCULATE (
    SUM ( 'Booking List'[Containers] ),
    CROSSFILTER ( 'Booking List'[a], 'table'[a], BOTH )
)

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • Dangar332's avatar
    Dangar332
    Resident Rockstar
    2 years ago

    Hi, smallfires0628 

     

    check your table 'Booking List' or slicer feild table contains any relationship

    if contains then check direction of relationship of both table

     

    if 'Booking List' or slicer feild table not contain relationship then your slicer not affect on any visual in report

    • smallfires0628's avatar
      smallfires0628
      Helper I
      2 years ago

      It has a one to many relationship with another table (the 1 is on the Booking List side) and it has a single cross filter direction. It doesn't have a relationship with any of the filters table like the date table. But the table it's connected to has a relationship to the filters table. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi smallfires0628 

        You can use crossfilter() function.

        e.g The column between the tables to connect is named a.

        Total Containers =
CALCULATE (
    SUM ( 'Booking List'[Containers] ),
    CROSSFILTER ( 'Booking List'[a], 'table'[a], BOTH )
)

        Best Regards!

        Yolo Zhu

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi smallfires0628 

    Please use REMOVEFILTER in your measure
    Like (say you are using Product name in your slicer and you want to turnoff the filter)
    so your measure like

     

    Total Containers = Calculate(sum('Booking List'[Containers]),REMOVEFILTERS(YourTable[Product]))

     

     https://learn.microsoft.com/en-us/dax/removefilters-function-dax

     


    Let me know if that works for you


    If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin