Forum Discussion

smallfires0628's avatar
smallfires0628
Icon for Helper I rankHelper 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.

Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident 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
    Icon for Helper I rankHelper 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.