Skip to content

ISINTEGER

Whether a value is a whole number.

Group: Information. Compatible with DAX.

Syntax

ISINTEGER ( <value> )

Parameter	Type	Description
`value`	Value	What is tested: a constant, a column in a row context, a measure or any expression.

Returns

Boolean. TRUE when the value is of the whole number type (Int64), FALSE otherwise.

Remarks

The type decides, not the value: dividing two whole numbers gives a decimal number, so ISINTEGER ( 14 / 2 ) is FALSE although the result is 7. INT and CONVERT ( x, INTEGER ) give whole numbers.
A sum or a count of a whole number column is a whole number; a mean is not.
Text, dates and blanks are FALSE. ISINT64 is the same test.

Examples

Values and their types

EVALUATE
ROW (
    "7", ISINTEGER ( 7 ),
    "7.5", ISINTEGER ( 7.5 ),
    "14 / 2", ISINTEGER ( 14 / 2 ),
    "INT ( 7.5 )", ISINTEGER ( INT ( 7.5 ) ),
    "Text 7", ISINTEGER ( "7" ),
    "Blank", ISINTEGER ( BLANK () )
)

7	7.5	14 / 2	INT ( 7.5 )	Text 7	Blank
TRUE	FALSE	FALSE	TRUE	FALSE	FALSE

ISINT64, ISDOUBLE, ISNUMERIC, INT, CONVERT.

Last updated 3 November 2026 · OpenBI Studio 0.3.74