Forum Discussion
Excluding a visual from page filter
I have a visual for ranking sellers by closed won opportunities. This visual does not show all closed won opportunities because of the month page filter. This filter cannot be removed because of other visuals on the dashboard utilizing it.
Below is my measure for rank closed won opportunities. How can I write this measure to exclude the filters on the page?
Rank Closed Won Opps =
IF (
ISBLANK([Total Closed Won Opps]),
BLANK(),
RANKX ( ALL ( 'Employees Activity'[Full Name] ), [Total Closed Won Opps] ) )
Measure used to calculate Total Closed Won Opps =
CALCULATE(
[ Total Opps Amount],
Opportunities[sales_stage] = "Closed Won")
Thank you.
Alicia83B , you can use removefilters or all
example
Rank Closed Won Opps =
IF (ISBLANK([Total Closed Won Opps]),
BLANK(),
RANKX ( ALL ( 'Employees Activity'[Full Name] ), calculate([Total Closed Won Opps], all(Table[Column]) ) )
4 Replies
Alicia83B , you can use removefilters or all
example
Rank Closed Won Opps =
IF (ISBLANK([Total Closed Won Opps]),
BLANK(),
RANKX ( ALL ( 'Employees Activity'[Full Name] ), calculate([Total Closed Won Opps], all(Table[Column]) ) )
amitchandak This did not work. I got a red swiggly line as soon as I added everything after the , all(Table[Column]) ) )
I think he's just missing a final closing parenthesis. Oh, and replace Table[Column] with whatever filtering you want to ignore.
