Create a measure that does not respond to visual filters

[Anonymous]

Hello, 

I am trying to create a line and clustered column chart where the line data does not respond to the filters i have for the columns. In this chart, the columns display total projected $ impact for different business divisions with specific filters. I want the line to show total number of financial events for each column without the specific filters on the bar chart effecting the number. Right not the number is showing a total of 53 events when it should be 250. 

I have tried creating a measure that would count this value:

Events = CALCULATE(COUNT('Risk Event Global'[Event ID]),

ALL('Risk Event Global'[Event ID]),

FILTER('Risk Event Global', 'Risk Event Global'[Event Status] in {"Open","Draft"}))

I have seen in these forums that ALL() has worked to solve this issue for others, but I am still getting the same result. 

Here is the chart:

Here are the filters on the visual:

Here is the table:

[v-shex-msft]

Hi @Anonymous,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@Anonymous , Try like

Events = CALCULATE(COUNT('Risk Event Global'[Event ID]),

FILTER(ALL('Risk Event Global'),, 'Risk Event Global'[Event Status] in {"Open","Draft"}))