Forum Discussion
smallfires0628
Helper I
Helper IMeasure 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.
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.
smallfires0628Helper I
Helper IIt 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.
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.