05. Information Functions
Detect the state of your data: Is it blank? Is it filtered?
ISBLANK
Check for missing values (nulls) to avoid calculation errors.
👉
HASONEVALUE
Essential for Totals. Checks if only one item is currently visible.
👉
ISFILTERED
Returns TRUE if a specific column has a direct filter applied.
👉
ISCROSSFILTERED
Returns TRUE if a column is filtered directly OR indirectly (via relationship).
👉
USERELATIONSHIP
Activate an inactive relationship for a specific calculation.
👉
⬅ Back to DAX Menu