topic Re: Excluding a visual from page filter in DAX Commands and Tips

Excluding a visual from page filter

Alicia83B — Fri, 21 Oct 2022 13:53:10 GMT

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.

Re: Excluding a visual from page filter

amitchandak — Fri, 21 Oct 2022 14:47:10 GMT

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]) ) )

Re: Excluding a visual from page filter

Alicia83B — Fri, 21 Oct 2022 21:56:29 GMT

amitchandak This did not work. I got a red swiggly line as soon as I added everything after the , all(Table[Column]) ) )

Re: Excluding a visual from page filter

AlexisOlson — Sun, 23 Oct 2022 18:47:06 GMT

I think he's just missing a final closing parenthesis. Oh, and replace Table[Column] with whatever filtering you want to ignore.

Re: Excluding a visual from page filter

Alicia83B — Mon, 24 Oct 2022 12:14:04 GMT

AlexisOlson Thank you.