write DAX for TOP 5 AND BOTTOM 5

Anonymous Create a calculated column for counting occurrences

MatchCount =
CALCULATE(
COUNTROWS('Table'),
ALLEXCEPT('Table', 'Table'[Country], 'Table'[Matching])
)

 

 Create measures for top 5 and bottom 5 auto match and manual match

Top5AutoMatch =
CALCULATE(
[MatchCount],
FILTER(
'Table',
'Table'[Matching] = "auto match"
),
TOPN(5, ALL('Table'[Country]), [MatchCount], DESC)
)

Bottom5AutoMatch =
CALCULATE(
[MatchCount],
FILTER(
'Table',
'Table'[Matching] = "auto match"
),
TOPN(5, ALL('Table'[Country]), [MatchCount], ASC)
)

Top5ManualMatch =
CALCULATE(
[MatchCount],
FILTER(
'Table',
'Table'[Matching] = "manual match"
),
TOPN(5, ALL('Table'[Country]), [MatchCount], DESC)
)

Bottom5ManualMatch =
CALCULATE(
[MatchCount],
FILTER(
'Table',
'Table'[Matching] = "manual match"
),
TOPN(5, ALL('Table'[Country]), [MatchCount], ASC)
)

 

Create a new table for the slicer:

SlicerTable =
DATATABLE(
"Selection", STRING,
{
{"Top 5"},
{"Bottom 5"}
}
)

 

Create a measure to switch between top 5 and bottom 5:

DAX
SelectedMatchType =
SWITCH(
SELECTEDVALUE('SlicerTable'[Selection]),
"Top 5", [Top5AutoMatch] + [Top5ManualMatch],
"Bottom 5", [Bottom5AutoMatch] + [Bottom5ManualMatch]
)

 

 

Add a clustered column chart to your report.
Add Country to the Axis.
Add SelectedMatchType to the Values.
Add the SlicerTable to the report and use it as a slicer

Thanks for the replies from ThxAlot and bhanu_gautam.

 

Hi Anonymous ,

 

Have you solved your problem? If it is solved, please mark the reply that help you as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster. If there are any more questions, please feel free to let us know. Thanks a lot!

 

Best Regards,
Zhu

 

Hi Anonymous 

We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.