Forum Discussion
Solved
RANK function with two level filters
Hello, I have been trying to find a solution to the following problem, which I will explain using the sample report linked below: RANK - Adventure Works DW 2020.pbix I have a matrix visual w...
If you are always excluding Corporate HQ then you can use
Total Sales Rank ALL = RANK( SKIP, Filter(ALL( 'Sales Territory'[Region] ),[Region]<>"Corporate HQ"), ORDERBY( [Total Sales] ) )
If you are always excluding Corporate HQ then you can use
Total Sales Rank ALL =
RANK(
SKIP,
Filter(ALL( 'Sales Territory'[Region] ),[Region]<>"Corporate HQ"),
ORDERBY( [Total Sales] )
)
Thanks a lot! Ideally, I would have another slicer to choose regions to be excluded - maybe based on additional table added to the model but I just can't figure it out. But your solution will work for me too 🙂