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”)
It’s difficult for the Forum members to judge and provide the results without looking at the PBIX file. And involves much of the guessing work for them thereby consuming much of their time.
Since you haven’t attached the PBIX file, I’ve tried to replicate the scenario in my file where I’ve applied a page level filter over a Customer and then in the table visual want to exclude that same external filter. So in that case, in order to ignore that filter, we can use the DAX function’s “REMOVEFILTERS()” or “ALL()” and they both will yield the same results.
I’m attaching the working of the PBIX file for the reference purposes.
Hoping you find this useful and can replicate the technique in your PBIX file.
Important Note: If this doesn’t solve your query then please either attach the working or demo PBIX file so that forum members can further provide you with the assistance.
