DAX CALCULATE Function MCQS

Q. What does CALCULATE() do in DAX?

A

Formats a number

B

Modifies the filter context of an expression

C

Creates a new table

D

Sorts a visual

Solution:

CALCULATE() changes the filter context under which its first argument is evaluated.

Q. In CALCULATE(, , ), what is the first argument?

A

A filter condition

B

The value to be calculated

C

A table name

D

A column name

Solution:

The first argument to CALCULATE() is the base expression being evaluated; every argument after it is a filter.

Q. What is a measure in Power BI?

A

A stored, static row-level value

B

A dynamic calculation based on the current filter context

C

A type of chart

D

A data connector

Solution:

A measure recalculates dynamically based on filter context and isn’t stored in the table.

Q. Which function counts the number of unique values in a column?

A

COUNT()

B

DISTINCTCOUNT()

C

SUM()

D

AVERAGE()

Solution:

DISTINCTCOUNT() returns the count of unique values in a column, as opposed to COUNT()’s total row count.

Q. What does CALCULATE([Total Sales], ALL(Sales[Region])) do?

A

Filters to a specific region only

B

Removes any existing filter on the Region column

C

Deletes the Region column

D

Sums the Region column as text

Solution:

ALL() inside CALCULATE() removes filters from the specified column, overriding whatever region filter was previously applied.

Q. Why is CALCULATE() considered the most important DAX function?

A

It's the fastest function

B

Most advanced DAX patterns, including time intelligence, are built on its ability to modify filter context

C

It's the only function that can use SUM()

D

It replaces the need for relationships

Solution:

CALCULATE()’s filter-context manipulation underlies most advanced DAX techniques, including time intelligence functions.

Q. A CALCULATE()-filtered measure returns the same result no matter what filter is passed. What's the likely cause?

A

The filter condition doesn't match the actual data (wrong spelling, case, or column)

B

CALCULATE() is broken in this version of Power BI

C

The measure needs a relationship to itself

D

The visual needs to be resized

Solution:

If the filter text doesn’t exactly match the underlying data values, CALCULATE() effectively applies no meaningful filter.

DAX CALCULATE Function MCQS

Q. What does CALCULATE() do in DAX?

Solution:

Q. In CALCULATE(, , ), what is the first argument?

Solution:

Q. What is a measure in Power BI?

Solution:

Q. Which function counts the number of unique values in a column?

Solution:

Q. What does CALCULATE([Total Sales], ALL(Sales[Region])) do?

Solution:

Q. Why is CALCULATE() considered the most important DAX function?

Solution:

Q. A CALCULATE()-filtered measure returns the same result no matter what filter is passed. What's the likely cause?

Solution:

Related Questions

Q. DAX Variables MCQS

Q. DAX Text Functions MCQS

Q. DAX Logical Functions MCQS

Get Question Bank