Power BI Information Functions – [11 DAX Examples]

In this Power Bi tutorial, we will discuss the Power BI Information functions and 11 DAX examples of Power BI information functions. And also we will discuss the below points:

• What is Power Bi Dax Information Function
• List of available Power BI Information Function
• Power Bi DAX Information Function (11 Examples)

What is Power Bi Dax Information Functions

The Power Bi Dax information looks at the cell or row that is provided as an argument and tells you whether the value matches the expected type.

List of available Power BI Information Function

Here we will see the List of important available Power BI Information Functions with syntax.

Function	Description	Syntax
CONTAINS	If values for all referred column exists or are contained, in those columns, then the function returns true or else return false	CONTAINS(<table>, <column value> <value>[, <column value>, <value>]…)
CONTAINSROW	If a row value exists or is contained in a table, then the function returns true or else return false	CONTAINSROW(<tableExpression>, <ScalarExpression>[, <ScalarExpression>,…])
CONTAINSSTRING	This function returns true or false indicating whether one string contains another string.	CONTAINSSTRING(<within text>, <find text>)
HASONEFILTER	The number of directly filtered values on ColumnName is One, then the function returns true or else returns false	HASONEFILTER(<column name>)
HASONEVALUE	The context for ColumnName has been filtered down to one distinct value only, then the function returns true or else return false	HASONEVALUE(<columnName>)
ISBLANK	This function returns true if the value is blank or else returns false.	ISBLANK(<Value>)
ISERROR	This function returns true if the value is an error or else returns false.	ISERROR(<value>)
ISLOGICAL	This function checks whether the value is a logical value i.e. TRUE/FALSE, then it returns true or else returns false	ISLOGICAL(<value>)
ISNONTEXT	This function checks whether a value is nontext (blanks consider as non-text) then it returns true or else returns false	ISNONTEXT(<value>)
ISNUMBER	This function checks whether a value is a number, then it returns true or else returns false	ISNUMBER(<value>)
ISTEXT	This function checks whether a value is a text then it returns true or else returns false	ISTEXT(<value>)

Read Power Bi count function

Power Bi DAX Information Function Example

Here we will see 11 Power Bi Dax Information Function Examples.

Example 1: Using Power BI Contains function

Here we will see how to use CONTAIN function in the Power bi desktop.

We will use the below sample table having three columns Category, sales, and unit price.

Here we will check if any specific value exists in a category column, if it contains then it returns true or else false.

Here we will check in the category column the Office Supplies text is present or not.

Text Contains = CONTAINS('Table','Table'[Category],"Office Supplies")

Read Power BI average function with Examples

Example 2: Using Power Bi CONTAINSROW function

Here we will see how to use the CONTAINSROW function in power bi with an example.

We will use the below sample table having three columns Category, sales, and unit price.

Now create a measure in Power BI to calculate wheather a Technology is present in a row of the Category column or not. For this write the below measure:

Measure = FILTER(SUMMARIZE('Table','Table'[Category]), CONTAINSROW({ ("Technology") }, [Category]))

Read Power BI MAX and MIN function

Example 3: Using Power Bi CONTAINSSTRING Function

Here we will see how to use the CONTAINSSTRING function in power bi with an example.

We will use the below sample table having three columns Category, sales, and the unit price.

Now we will create a measure in Power BI, in which we will find the text i.e. substring of within text. For example, here we will check in Office supplies text, Office string is present or not.

Measure = ROW("Case1", CONTAINSSTRING("Office Supplies","Supplies"))

Read Power BI DAX Logical functions

Example 4: Using Power Bi HASONEFILTER Function

Here we will see how to use the HASONEFILTER function in power bi desktop using the measure.

We will use the below sample table having three column Category, sales, and the unit price

Now we will create a measure, to see how to use HASONEFILTER() to return the filter for the category if there is one filter, or it will return blank if there is no filter or more than one filter.

Measure = IF(HASONEFILTER('Table'[Category]),FILTERS('Table'[Category]),BLANK())

Read Power BI Slicer – How to use

Example 5: Using Power Bi HASONEVALUE Function

Here we will see how to use the HASONEVALUE function in power bi desktop for example.

We will use the below sample table having three columns Category, sales, and unit price.

Now we will create a measure that will filter the category column to the one district value only.

Measure = HASONEVALUE('Table'[Category])

Read Power BI Matrix

Example 6: Using Power Bi ISBlANK functions

Here we will see how to use the ISBLANK function using the measure in power bi desktop with example.

We will use the below sample table having four columns i.e id, category, quantity, and sales.

So, first, we will calculate the total sales, and then we will check the blank value present in the measure, if present true or else false.

• To calculate total sales create a measure, then write the below measure:

Total sales = SUM('Table'[Sales])

• Now to check the blank value create an another measure, then write the below measure:

Measure 2 = ISBLANK('Table'[Total sales])

Read How to use Power bi maps

Example 7: Using Power Bi ISERROR function

Here we will see how to use the ISERROR function using the measure in the Power bi.

We will use the below sample data having four columns Id, category, quantity, and sales.

So, here we will calculate the sum of the quantity divided by the count of ID, then this we will wrap inside Power BI ISERROR function.

If there is an error in calculation then it returns TRUE or else returns FALSE.

To find the error in the calculation, write the below measure:

Measure 3 = ISERROR(SUM('Table'[Quantity])/ COUNT('Table'[ID]))

Read How to use Microsoft Power BI Scatter Chart

Example 8: Using Power BI ISLOGICAL function

Here we will see how to use the power bi ISLOGICAL function in power bi.

So, here we will check the value whether the value the logical or not.

So for this, I have taken measure 2, which I have created to show how to use the ISBLANK function. if measure2 is logical then it returns true or else returns false.

To check whether the measure is logical or not, for this create a measure.

Then write the below measure:

Measure 4 = ISLOGICAL([IS blank])

Read Microsoft Power BI Combo Chart

Example 9: Using Power Bi ISNONTEXT function

Here we will see how to use the Power BI ISNONTEXT function using the measure in power bi desktop.

We will use the below sample table, having four columns Id, category, quantity, and sales.

So here we will count the Quantity, then we will check whether the value is text or non-text, if it is non-text then it returns true or else returns false.

• To check the value is text or nontext, create a measure, then write the below measure:

Measure 4 = ISNONTEXT( COUNT('Table'[Quantity]))

Read Power Bi key influencers

Example 10: Using Power Bi ISNUMBER function

Here we will see how to use the Power Bi ISNUMBER function using the measure.

Here we will see how to use the Power Bi ISNUMBER function using the measure.

Here we will use the below sample table, having four columns Id, category, quantity, and sales.

So, here we will check if the sum of sales value is a number or not by using ISNUMBER().

To check whether the value is a number or not,

Measure 4 = IF(ISNUMBER( SUM('Table'[Sales])),"Is Number", "Is not number")

Read Power BI Donut Chart

Example 11: Using Power Bi ISTEXT function

Here we will see how to use the Power bi ISTEXT function using a measure.

We will use the below sample table, having four columns Id, category, quantity, and sales.

So, here we will check whether the sum of sales value is text or non-text by using the measure.

To check whether the value is text or not, for this create a measure, then write the below measure:

Measure 4 = IF(ISTEXT( SUM('Table'[Sales])),"Is Text", "Is non text")

You may like the following Power bI tutorials:

• Power bi gauge chart
• Power BI combine columns from two tables
• Power BI Export Data
• Power BI Clustered Column Chart
• How to change data source in Power BI

In this Power Bi tutorial, we learned different types of Power Bi Information functions with examples, such as:

• What is Power Bi Dax Information Function
• List of available Power BI Information Function
• Power Bi DAX Information Function Example
• Example 1: Using Power BI Contains function
• Example 2: Using Power Bi CONTAINSROW function
• Example 3: Using Power Bi CONTAINSSTRING Function
• Example 4: Using Power Bi HASONEFILTER Function
• Example 5: Using Power Bi HASONEVALUE Function
• Example 6: Using Power Bi ISBlANK functions
• Example 7: Using Power Bi ISERROR function
• Example 8: Using Power BI ISLOGICAL function
• Example 9: Using Power Bi ISNONTEXT function
• Example 10: Using Power Bi ISNUMBER function
• Example 11: Using Power Bi ISTEXT function