Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Let visual be ignored by specific filter(s)

Hi all,

We're running into a problem regarding filtering on a visual. The visual uses "Week" for the x axis, throughout the report we are using the filters "Week", "Month" and "Year" to filter visuals using the filter pane (we're not using slicers in our reports). These 3 fields are part of the same table in our dataset.

 

We want to set up some visuals so that these filters don't affect specific visuals (these visuals need to show all weeks all the time). We've tried using:

CALCULATE ( SUM( [Amount] ) , ALL ( CALENDAR ) )

but without success. The visual continues to change when we use the filters in the filter pane.

 

What are we missing here?

 

Thanks!

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

    Could you please try to add the field "week" of table "UNIT" into Filters pane instead of the field "WeekNr" of table "CALENDAR"?

    Best Regards

    Rena

14 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

    Which table the field Amount is from? Please try to change the table CALENDAR in the formula to the table where the field amount is: 

    CALCULATE ( SUM( [Amount] ) , ALL ( TABLENAME) )

    Best Regards

    Rena

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello Anonymous ,

       

      When I do that, the graph shows the total amount for every week. I get a horizontal line, which is not correct.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous ,

        Could you please provide the fields which applied to this column chart and some sample data(exclude sensitive data)? Please also provide the formula if applied any measure or calculated column.

        Best Regards

        Rena