Limitation: Top 10, Show others

Dimension limits and "Others" in Power BI

Qlik's dimension limits show the top N values plus an optional "Others" row with the rest. Power BI's Top N visual filter covers the first part. The "Others" row needs a helper dimension table with an extra "Others" member and a measure, because Power BI can't show a member that isn't in the data.

Partial / different approach Power BI UI DAX

Short answer: For the top N alone, use the filter pane: Filter type: Top N, by the measure. For top N plus Others, add a calculated table with the product names plus one "Others" row, relate or TREATAS it, and write a measure that returns the remainder on the "Others" row.

What it does in Qlik

In chart properties, each dimension can be limited to a fixed number, an exact value, or a relative value of the measure. Show others groups the hidden values into one row labelled "Others". The limit reacts to selections.

Qlik example

Qlik chart properties

Dimension: Product
  Limitation: Fixed number, Top 10, by Sum(Sales)
  Show others: on   (label "Others")

Power BI equivalent

Top N filter (no Others)

In the filter pane, open the dimension field on the visual, set Filter type to Top N, enter 10, and drag the measure into By value. It reacts to slicers like Qlik's limit does.

Top N plus Others (DAX)

DAX

// Calculated table: product names plus an "Others" member
Product axis =
UNION ( DISTINCT ( Product[Product] ), { "Others" } )

// Measure used in the visual, with 'Product axis'[Product] on the axis
Sales top 10 + others =
VAR n = 10
VAR ranked =
    TOPN ( n, ALLSELECTED ( Product[Product] ), [Sales] )
VAR item = SELECTEDVALUE ( 'Product axis'[Product] )
RETURN
    IF (
        NOT ISINSCOPE ( 'Product axis'[Product] ), [Sales],   // total row: everything
    IF (
        item = "Others",
        CALCULATE ( [Sales], EXCEPT ( ALLSELECTED ( Product[Product] ), ranked ) ),
        IF ( item IN ranked, CALCULATE ( [Sales], TREATAS ( { item }, Product[Product] ) ) )
    ) )

Leave 'Product axis' disconnected and let TREATAS do the filtering. Sort the axis by the measure and add a sort column so Others stays last.

Gotchas and behaviour differences

The Top N filter can return more than N rows when values tie at the cut-off (DAX TOPN keeps ties too). Qlik's fixed number limit cuts at exactly N.
Totals: with a Top N filter, the visual total sums only the visible rows. Qlik's total, with Others on, includes everything. The Others pattern above keeps the full total.

Official documentation

Changing the data of a visualization (Qlik Help)
Filter types in Power BI reports (Microsoft Learn)
TOPN function (DAX) (Microsoft Learn)
TREATAS function (DAX) (Microsoft Learn)

Rank(Sum(Sales)) Rank Qlik's Rank() ranks rows within the current column segment and has its own tie modes and a text format ("3 - 4"). In DAX, use RANKX or the newer RANK window function. Pick the ties option deliberately. Partial / different approach Avg(Aggr(Sum(Sales), Customer)) Aggr (nested aggregation) Aggr builds a virtual table of aggregated values, for example sales per customer, so you can aggregate again. In DAX that is an iterator (AVERAGEX, MAXX, COUNTROWS(FILTER(...))) over VALUES or SUMMARIZE that calls a measure. Partial / different approach Island table with no key to the model, used by expressions Data islands (disconnected tables) A Qlik data island is a table with no field in common with the model; expressions read its selection. Power BI has the same idea: a disconnected table without relationships, used in a slicer and read with SELECTEDVALUE inside measures. Direct equivalent

Spotted an error or a better pattern? QlikToDax is maintained by a working BI consultant; corrections are welcome via the About page. Last reviewed 2026-10-25.