Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@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]) ) )
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |