UMAP OpenBI

A map of the rows in two dimensions, near rows near each other (UMAP).

Group: Many variables at once. OpenBI’s own: DAX has no function of this name.

Syntax

UMAP ( <table>, <key> [, <settings>], <name>, <expression> [, <name>, <expression>] … )

Returns

Table. A row for each row of the table that has every variable: Key, then D1, D2 (and more with dims) with the row's place on the map.

Remarks

• UMAP (uniform manifold approximation and projection) lays the rows out so that rows alike in their variables lie near each other. Distances between groups far apart mean little, and the axes have no units.
• neighbors is how many nearest rows each row looks to: few for fine detail, more for the overall shape. min_dist is how closely rows may pack together.
• The same rows and settings always give the same map; another seed gives a different map with the same neighbourhoods.
• The settings are read as such only when they come right after the key and hold an =; an unknown setting is an error.
• Every variable is first put on one scale: how many standard deviations each row lies above or below that variable's mean. Liters and kroner then weigh alike, and a change of units changes nothing.
• A row where any variable is blank is left out. A variable must be a number on every row (text is an error, even text that reads as a number), and one that is the same on every row is an error too.
• The map needs more rows than dimensions plus one.

Compared with DAX

An OpenBI function: DAX has none like it, so a measure or query that uses it works in OpenBI only, not in Power BI or Analysis Services.

Examples

Two groups of shops, apart

With three neighbours each, the small shops and the big shops form two tight groups, well apart.

EVALUATE
VAR Shops =
    DATATABLE (
        "Shop", STRING, "Liters", INTEGER, "Visits", INTEGER,
        {
            { "A", 100, 10 }, { "B", 110, 12 }, { "C", 95, 9 },
            { "D", 400, 30 }, { "E", 420, 33 }, { "F", 390, 28 }
        }
    )
RETURN
    UMAP ( Shops, [Shop], "neighbors=3", "Liters", [Liters], "Visits", [Visits] )

Places by location and crates

EVALUATE
UMAP (
    Places,
    Places[District],
    "Lat", Places[Lat],
    "Lon", Places[Lon],
    "Crates", Places[Crates]
)

Related functions

PCA.SCORES, KMEANS, PCA.COMPONENTS.

Last updated 3 November 2026 · OpenBI Studio 0.3.74