FALSE

How to Use the Power BI DAX function FALSE

What is the FALSE Function in Power BI?

The FALSE function is a DAX function that returns the Boolean value false. This function can be used in different ways to manipulate data in Power BI. For instance, it can be used to filter data or create a new column with a false value.

Syntax of the FALSE Function

The syntax of the FALSE function is as follows:

FALSE()

The function does not require any argument, and it returns the Boolean value false.

How to Use the FALSE Function in Power BI

Using the FALSE Function in a Filter

The FALSE function can be used in a filter to exclude rows from a table. To use the FALSE function in a filter, follow the steps below:

1. Select the table that you want to filter.

2. Click on the filter icon on the table.

3. Select the column that you want to filter.

4. Select the filter type as "Text Filters", then select "Equals".

5. In the text box, type FALSE() and press Enter.

This will filter out all the rows that have a false value in the selected column.

Using the FALSE Function in a Calculated Column

The FALSE function can also be used in a calculated column to create a new column with a false value. To use the FALSE function in a calculated column, follow the steps below:

1. Select the table that you want to add a calculated column to.

2. Click on "New Column" on the table.

3. In the formula bar, type the name of the column and the FALSE function as follows:

Column Name = FALSE()

4. Press Enter to create the new column.

This will create a new column with a false value in all the rows of the table.

The FALSE function is a powerful DAX function that can be used in Power BI to manipulate data in different ways. It can be used to filter data or create a new column with a false value. By following the steps outlined in this article, you can easily use the FALSE function in Power BI.

Power BI DAX Training Courses by G Com Solutions (0800 998 9248)

Upcoming Courses

Contact Us

    Subject

    Your Name (required)

    Company/Organisation

    Email (required)

    Telephone

    Training Course(s)

    Your Message

    Upload Example Document(s) (Zip multiple files)