The majority of DAX functions return a single value based on an aggregation or a logical evaluation of a table or column. For example, the COUNTROWS() and DISTINCTCOUNT() functions return individual numeric values based on a single table and a single column input parameter, respectively. The DAX functions which return individual values as their output, including information functions, such as ISBLANK() and LOOKUPVALUE(), are referred to as scalar functions. For relatively simple datasets and at early stages in projects, most DAX measures will reference a single scalar function with no other modifications, such as with CALCULATE().
In addition to scalar functions, many DAX functions return a table as the output ...
