Apply different filters to measures in the same sheet

[coelh019]

Hello. I am trying to calculate an annual rate for which I need two overall counts of employees. To verify the results, I have created two tables with the overall sum of days on leave/worked by employees. To generate these counts, I have applied filters on the sheet by year, type of leave, status (active or not) and other categories. However, I only want the Year filter to apply to one of two tables. Is there a way to make this work or should I move this table to another sheet? Thanks in advance.

I have tried to create an alternate state for the second sheet, but on that state I am unable to generate new employee counts if the year changes.

[Lisa_P]

For the measure in the second chart that you don't want to change based on the Timesheet Year,

add this set {[Timesheet Year]} to the beginning of the expression/measure to ignore selections on this field.

[coelh019]

Sorry, I did not express myself correctly. What I would like to do is apply the Timesheet Year and Active Status filters to both tables, but the remaining filters on the sheet would only apply to one of them. I haven't found a way to do this yet; I was only able to set an alternate state for the table on the bottom for which no filters would apply.

[nina2]

Hi, 

You can write the dimensions of the remaining filters with an equal in the set analysis of the measure you don't want to be impacted by those filters

For example, if you want to select a month in the first table but not in the second, you can add "MONTH=" in the set analysis of the measure "leaves" of the second table