Creating a Slicer that filters top 5 and bottom 5 branches

Anonymous — Thu, 10 Aug 2023 13:35:45 GMT

I tried this but it only works for visual that contains branchlocation and profit
Measure 1:

BottomNFilter =

VAR TotalBranches = COUNTROWS(ALL(Geography[BranchLocation]))

VAR BottomN = TotalBranches - [SelectedTopNumber] + 1

RETURN IF([BranchRankByAmount] >= BottomN, 1, 0)
Measure 2:

BranchRankByAmount = IF(HASONEVALUE(Geography[BranchLocation]), RANKX(ALL(Geography[BranchLocation]), [Total Sales],, DESC))

Measure 3:

CombinedFilter =

IF (

HASONEVALUE('TopN'[Index]),

IF (

VALUES('TopN'[Index]) = "Top 5 Branches",

[Top5Branches],

[BottomNFilter]

)

Measure 4:

SelectedTopNumber =

IF (

HASONEVALUE('TopN'[index]),

SWITCH (

VALUES('TopN'[index]),

"Top 5 Branches", 5,

"Bottom 5 Branches", 5

)

Measure 5:

Top5Branches = VAR SelectedNumber = [SelectedTopNumber]

RETURN IF([BranchRankByAmount] <= SelectedNumber, 1, 0)

i drag combined filter to each of the visual i want the slicer to filter, but it only work for table that shows branchlocation and some other column but lets say i do number of customers by region on a map where the lat and long is based on branch location it does not work,when i choose top 5 it shows all the branches but when i choose bottom 5 the map is empty same for other visuals

Re: Creating a Slicer that filters top 5 and bottom 5 branches

some_bih — Mon, 14 Aug 2023 06:34:26 GMT

Hi Anonymous I understand your slicer selection affect result on different visuals? When you analyze your specific visual, measure and solution (with slicer) working fine? If yes, then create separate pages for different visuals, if it is what is ok for you.

Hope this help.

topic Creating a Slicer that filters top 5 and bottom 5 branches in DAX Commands and Tips

Creating a Slicer that filters top 5 and bottom 5 branches

Re: Creating a Slicer that filters top 5 and bottom 5 branches