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.

FunctionDescriptionSyntax
CONTAINSIf values for all referred column exists or are contained, in those columns, then the function returns true or else return falseCONTAINS(<table>, <column value> <value>[, <column value>, <value>]…)
CONTAINSROWIf a row value exists or is contained in a table, then the function returns true or else return falseCONTAINSROW(<tableExpression>, <ScalarExpression>[, <ScalarExpression>,…])
CONTAINSSTRINGThis function returns true or false indicating whether one string contains another string.CONTAINSSTRING(<within text>, <find text>)
HASONEFILTERThe number of directly filtered values on ColumnName is One, then the function returns true or else returns falseHASONEFILTER(<column name>)
HASONEVALUEThe context for ColumnName has been filtered down to one distinct value only, then the function returns true or else return falseHASONEVALUE(<columnName>)
ISBLANKThis function returns true if the value is blank or else returns false.ISBLANK(<Value>)
ISERRORThis function returns true if the value is an error or else returns false.ISERROR(<value>)
ISLOGICALThis function checks whether the value is a logical value i.e. TRUE/FALSE, then it returns true or else returns falseISLOGICAL(<value>)
ISNONTEXTThis function checks whether a value is nontext (blanks consider as non-text) then it returns true or else returns falseISNONTEXT(<value>)
ISNUMBERThis function checks whether a value is a number, then it returns true or else returns falseISNUMBER(<value>)
ISTEXTThis function checks whether a value is a text then it returns true or else returns falseISTEXT(<value>)
Power BI Dax Information Function

Read Power Bi count function

See also  Power Automate Condition if a String is Empty

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.

Power BI Dax Information Function
Power BI Dax Information Function

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")
Power BI Dax Information Function
Power BI Dax Information Function

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.

Power Bi CONTAINSROW function
Power Bi CONTAINSROW function

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]))
Power Bi CONTAINSROW function
Power Bi CONTAINSROW function

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.

Power Bi CONTAINSSTRING Function
Power Bi CONTAINSSTRING Function

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"))
Power Bi CONTAINSSTRING Function
Power Bi CONTAINSSTRING Function

Read Power BI DAX Logical functions

See also  Power Apps Rich text editor control - How to use

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

Power BI Dax Information Function
Power BI Dax Information Function

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())
Power BI Dax Information Function
Power BI Dax Information Function

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.

Power Bi HASONEVALUE Function
Power Bi HASONEVALUE Function

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

Measure = HASONEVALUE('Table'[Category])
Power Bi HASONEVALUE Function
Power Bi HASONEVALUE Function

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.

 Power Bi ISBlANK functions
Power Bi ISBlANK functions

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])
 Power Bi ISBlANK functions
Power Bi ISBlANK functions

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.

See also  How to create a word document from a template in Power Automate

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

Power Bi ISERROR function
Power Bi ISERROR function

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]))
Power Bi ISERROR function
Power Bi ISERROR function

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])
Power Bi is logical function
Power Bi ISLOGICAL function

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.

 Power Bi ISNONTEXT function
Power Bi ISNONTEXT function

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]))
 Power Bi ISNONTEXT function
Power Bi ISNONTEXT function

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.

Power Bi ISNUMBER function
Power Bi ISNUMBER function

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")
Power Bi ISNUMBER function
Power Bi ISNUMBER function

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.

 Power Bi ISTEXT function
Power Bi ISTEXT function

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")
 Power Bi ISTEXT function
Power Bi ISTEXT function

You may like the following Power bI tutorials:

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
>