Dynamic Ranking

I am not sure I understand what you are asking

Can you please show an example of the selections you want to make and the expected outcome?

Anyway, here is how to get waht you are discussing in a column (I do not think this is what you need though)

Here how to get it with a measure

1. Create a Rank measure

Category Rank =
RANKX (
    FILTER ( ALL ( 'Category' ), [Total] > 0 ),   // Ignores zeros
    [Total],
    ,
    DESC,
    DENSE
)

2. Create Top Category (Dynamic) measure 

Top Category =
CALCULATE (
    FIRSTNONBLANK ( 'Category'[Category], 1 ),
    FILTER (
        ALL ( 'Category' ),
        [Category Rank] = 1
    )
)

3. Create Bottom Category (Dynamic) measure

Bottom Category =
CALCULATE (
    FIRSTNONBLANK ( 'Category'[Category], 1 ),
    FILTER (
        ALL ( 'Category' ),
        [Category Rank] = CALCULATE ( MAX ( [Category Rank] ), ALL ( 'Category' ) )
    )
)

4. Place in visuals

• Put Top Category and Bottom Category into a single-row table visual (instead of a card).

• Clicking one will act as a filter for your tablix (main detail table) because it’s a table visual, not a card.

• The Bottom Category will automatically ignore zeros due to the 

  FILTER ( ALL ( 'Category' ), [Total] > 0 ).

- Create a disconnected table with “Top Category” and “Bottom Category” labels.
- Use DAX to calculate the actual top/bottom category names dynamically (ignoring zeros).
- Build a measure that returns the selected category based on the label.
- Use a filter measure (ShowCategory = 1) to show only that category’s data in your main table.

Hi lherbert501 ,

Thanks for posting in Microsoft Fabric Community.

You can achieve this by creating two visuals: a selector table and a detail table.

The selector table will only display the top and bottom categories, and when you click on a row there, the detail table will update to show only that category’s data.

Below are the measures used in the setup:

Total1 =
SUM ( CategoryData[Total] )

Top Category Name =
MAXX (
    TOPN ( 1, FILTER ( ALL ( CategoryData[Category] ), [Total1] > 0 ), [Total1], DESC ),
    CategoryData[Category]
)

Bottom Category Name =
MAXX (
    TOPN ( 1, FILTER ( ALL ( CategoryData[Category] ), [Total1] > 0 ), [Total1], ASC ),
    CategoryData[Category]
)

Is Top Or Bottom =
VAR c = SELECTEDVALUE ( CategoryData[Category] )
RETURN IF ( c = [Top Category Name] || c = [Bottom Category Name], 1 )

TopBottom Label =
VAR c = SELECTEDVALUE ( CategoryData[Category] )
RETURN
IF (
    c = [Top Category Name],
    "Top category",
    IF ( c = [Bottom Category Name], "Bottom category" )
)

In the selector table, place Category, TopBottom Label, and optionally Total, then apply a visual-level filter where Is Top Or Bottom = 1. This gives you exactly two rows: the top category and the bottom category. Clicking a row in the selector table will cross-filter the detail table.

Selector Table:

Detail Table:

Detail Table responding to Selector Table:

I have attached .pbix for your reference.

Hope this helps. Please reach out for further assistance.

Thank you.