Daily DAX : Day 418 ISSELECTEDMEASURE

Power BI DAX: ISSELECTEDMEASURE() Function

Introduced in: December 2023 Update (Calculation Groups 2.0)

What is ISSELECTEDMEASURE()?

The ISSELECTEDMEASURE() function checks whether one or more specified measures are currently selected in a calculation item (inside a calculation group).

Syntax

ISSELECTEDMEASURE ( <measure1> [, <measure2>, ...] )

Return Value

TRUE – if at least one of the listed measures is the one currently being evaluated by the calculation item.
FALSE – otherwise.

Use Case: Dynamic Formatting or Logic Based on Selected Measure

This function is extremely useful when you want a calculation item to behave differently depending on which base measure the user has selected in a visual.

Real-World Example

Imagine you have a calculation group called "Dynamic Format" with one calculation item "Color Logic" that changes the font color of values:

  • Red if measure is Sales Amount
  • Blue if measure is Profit
  • Black for all others

DAX Code in the Calculation Item "Color Logic"

SWITCH (
    TRUE(),
    ISSELECTEDMEASURE ( [Sales Amount] ),   "Red",
    ISSELECTEDMEASURE ( [Profit] ),         "Blue",
    "Black"   -- default
)

This returns a color name that can be used in Dynamic Format String or conditional formatting.

Common Use Cases

Use Case Description
Dynamic Format Strings Show % sign only when certain measures are selected
Conditional Units (K, M, B) Show values in thousands only for large measures
Different Decimal Places 0 decimals for counts, 2 for currency measures
Custom Tooltips or Logic Apply different calculation logic only to specific measures

Important Notes

  • Only works inside calculation items of a calculation group.
  • You can list multiple measures: ISSELECTEDMEASURE([Sales], [Budget], [Forecast])
  • Works with measures from any table (including implicit measures).
  • Extremely powerful when combined with SELECTEDMEASURE(), SELECTEDMEASURENAME(), and dynamic format strings.

Summary: ISSELECTEDMEASURE() is the key function that enables truly dynamic, measure-aware formatting and logic in modern Power BI calculation groups.

Comments

Post a Comment

Popular posts from this blog

Daily DAX : Day 131 SELECTEDMEASURE

 The SELECTEDMEASURE function in Power BI's DAX (Data Analysis Expressions) language is a powerful tool used primarily within calculation groups to dynamically reference the measure currently being evaluated in a report. It’s part of the calculation group feature introduced to streamline complex reporting scenarios and improve maintainability by reducing the need to duplicate measure logic. What is SELECTEDMEASURE? SELECTEDMEASURE is a DAX function that returns a reference to the measure that is currently active or "selected" in the context of a calculation group. It doesn’t take any arguments and is typically used in the expression of a calculation item within a calculation group. This allows you to write generic logic that can dynamically apply to whichever measure is being evaluated in a visual, without hardcoding specific measure names. Syntax SELECTEDMEASURE()     Returns: A reference to the measure currently being evaluated in the report context. Use Case SELECTEDME...
Read more

Daily DAX : Day 446 INFO.CSDLMETADATA

Power BI DAX Function: INFO.CSDLMETADATA INFO.CSDLMETADATA` is a specialized DAX function introduced as part of a broader set of "INFO" functions (like `INFO.TABLES` or `INFO.MEASURES`) used for **model introspection**. It allows you to programmatically access the underlying structure of your Power BI semantic model. What does it do? The function returns a table with a single column containing the Conceptual Schema Definition Language (CSDL)  metadata of your model in XML format . In plain English, it exports a highly technical "blueprint" of your entire data model—including tables, columns, relationships, and measures—as a structured XML string. It is essentially the DAX equivalent of the `DISCOVER_CSDL_METADATA` Dynamic Management View (DMV) used in Analysis Services. --- Syntax and Output The syntax is straightforward as it requires no arguments: ```dax EVALUATE INFO.CSDLMETADATA() ``` Return Value : A table with one column and one row. Content : A long string ...
Read more

Daily DAX : Day 453 ENDOFWEEK

Power BI DAX Function: ENDOFWEEK Description The ENDOFWEEK function is a Time Intelligence function in DAX (Data Analysis Expressions) used in Power BI. It returns the date that represents the end of the week containing a specified date (typically Saturday, as weeks are considered to start on Sunday by default in DAX time intelligence). Syntax ENDOFWEEK( [, ]) : A column reference (usually from a Date table) or a date expression. Required. : Optional. Specifies the week-ending convention. Default is Saturday if omitted. Examples 1. Basic usage (default: week ends on Saturday): End of Week = ENDOFWEEK('Date'[Date]) For a date like January 8, 2026 (Thursday), this would return January 10, 2026 (Saturday). 2. In a measure for cumulative sales up to end of week: Total Sales to End of Week = CALCULATE( SUM(Sales[Amount]), DATESBETWEEN('Date'[Date], ST...
Read more