Stands in for whichever measure happens to be evaluated, inside calculation items or dynamic format strings. That lets one calculation group add, say, YTD behaviour to all measures at once.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains SELECTEDMEASURE in context, with comparison tables and the common traps.
Terms in this definition
- Measure
A figure like total revenue, worked out by aggregating fact table data wherever dimensions intersect within a semantic model.
- FORMAT
A DAX function that turns a value into text according to a format string, for instance "MMMM" to show a month's name. Since the output is text, numeric operations can't use it, and dynamic format strings were introduced to get around that.
- Calculation group
Lets you write common DAX logic like prior year or year-to-date once, as calculation items, and apply it to any explicit measure via SELECTEDMEASURE, so you need far fewer near-duplicate measures. Adding one to a semantic model discourages implicit measures.
- Architecture Definition Document
A key deliverable bringing together the main architecture artifacts across the four domains for every relevant state: baseline, transition and target. It sets out, in qualitative terms, what the architect intends.
- YTD
Year to date: totalling from January 1st (or a fiscal year start) up to now, which DAX handles through TOTALYTD or DATESYTD.
- ALL
A DAX function that ignores any filters and gives back every row of a table or every value of the named columns. Used within CALCULATE, it works as a modifier that clears filters, although REMOVEFILTERS states that intent more clearly where it is available.