Measure not affected by Filter

[smallfires0628]

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. 

[PijushRoy]

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

[Dangar332]

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]

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. 

[v-xinruzhu-msft · Accepted solution]

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.