pbi_create_topn_measure
Create a Top-N filter measure in Power BI to display only the top ranked dimension members in a visual, using a base measure and optional rank measure.
Instructions
Create a Top-N filter measure.
DAX template:
IF(RANKX(ALL({dim_table}[{dim_column}]), [{rank_measure}], , DESC) <= {N}, [{base}], BLANK())
Use as the value of a chart visual to surface only the top N members of a
dimension. rank_measure defaults to base_measure.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| n | Yes | ||
| table | Yes | ||
| overwrite | No | ||
| base_measure | Yes | ||
| measure_name | No | ||
| rank_measure | No | ||
| format_string | No | ||
| display_folder | No | Top-N | |
| dimension_table | Yes | ||
| dimension_column | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |