description | title |
---|---|
Learn more about: FIRST |
FIRST function (DAX) | Microsoft Docs |
[!INCLUDEapplies-to-visual-calculations]
Used in visual calculations only. Retrieves a value in the visual matrix from the first element of an axis.
FIRST ( <column>[, <axis>][, <blanks>][, reset] )
Term | Definition |
---|---|
column | The column to be retrieved. |
axis | (Optional) An axis reference. If omitted, the first axis of the Visual Shape definition is used. |
blanks | (Optional) An enumeration that defines how to handle blank values when sorting. The supported values are:
|
reset | (Optional) Specifies how the calculation restarts. Valid values are: None, LowestParent, HighestParent, or an integer. None is the default value. |
The value of <column> from the first element of the axis.
This function can only be used in a visual calculation.
The following visual calculation returns the sales amount of the first row on ROWS axis, that resets on the lowest parent.
FirstInternetSalesAmount = FIRST ( [Sum of SalesAmount], ROWS, LowestParent )
The screenshot below shows the visual matrix and the visual calculation expression: