DAX Function Reference - Visual Intelligence - page 372

FuNCTIoN DESCrIPTIoN

HASONEFILTER(< column >) Returns TRUE when the number of

directly filtered values on column is
one; otherwise returns FALSE .

HASONEVALUE(< column >) Returns TRUE when the context for

column has been filtered down to one
distinct value only; otherwise, the
function returns FALSE .

ISCROSSFILTERED(< column >) Returns TRUE when column or another

column in the same or related table is
being filtered.

ISFILTERED(< column >) Returns TRUE when column is being

filtered directly. If there is no filter
on the column or if the filtering hap-
pens because a different column in
the same table or in a related table
is being filtered, then the function
returns FALSE .

INForMATIoN FuNCTIoNS

Information functions, as shown in Table B-3, return additional information,
such as a data type.

TABle B-3 Information Functions

FuNCTIoN DESCrIPTIoN

CONTAINS(< table >,
< column1 >, < value1 >,
< column2 >, < value2 >,…)

Returns TRUE if values for all referred
columns exist, or are contained, in
those columns; otherwise, the func-
tion returns FALSE .

ISBLANK(< value >) Checks whether a value is blank, and

returns TRUE or FALSE .

ISERROR(< value >) Checks whether a value is an error,

and returns TRUE or FALSE .

ISLOGICAL(< value >) Checks whether a value is a logical

value ( TRUE or FALSE ), and returns
TRUE or FALSE .

ISNONTEXT(< value >) Checks whether a value is not text

(blank cells are not text), and returns
TRUE or FALSE .