Fabric Analytics Engineer DAX Measures Quiz

1. What does the HASONEVALUE() function check?

Whether a column has null values

Whether only one distinct value exists in filter context

Whether a measure is blank

Whether a relationship is active

2. What is the primary advantage of using CALCULATE over nested IF statements in Fabric reports?

Faster execution speed

Cleaner syntax and easier filter management

Reduces memory usage

Eliminates the need for relationships

3. True or False: A measure defined on one table cannot be used in visuals based on another table.

True

False

4. Which function calculates a running total across a sorted axis?

RUNNINGSUM

CUMULATIVE

SUMX with EARLIER

TOTALYTD

5. What does USERELATIONSHIP() do in DAX?

Activates an inactive relationship for a measure

Removes all relationships from a table

Creates a new relationship dynamically

Checks if a relationship exists

6. True or False: Implicit measures are automatically created for numeric columns in Fabric.

True

False

7. Which function creates a table of dates between two dates?

DATERANGE

DATESBETWEEN

CALENDAR

DATESPERIOD

8. What is the purpose of VALUES() in DAX?

Returns sum of values in a column

Returns distinct values from a column in current context

Filters rows based on values

Calculates average of values

9. True or False: SUMPRODUCT can be used to sum products of arrays in Fabric Analytics.

True

False

10. Which function returns blank if a condition is false in DAX?

IF

IFERROR

BLANK

ERROR

11. Which DAX function calculates a sum across rows in a table without respecting filter context?

SUM

SUMX

CALCULATE

SUMPRODUCT

12. True or False: Filter context is automatically inherited by all measures on a report page.

True

False

13. Which function is used to compare current period with previous period in DAX?

PARALLELPERIOD

PREVIOUSPERIOD

DATEADD

DATESBETWEEN

14. What does DISTINCTCOUNT() return in DAX?

Total count of rows

Number of unique values

Count of non-blank values

Cumulative count

15. True or False: A measure in Fabric can reference columns from multiple tables without explicit relationships.

True

False

16. Which of the following is a row context function in DAX?

SUMX

SUM

AVERAGE

COUNT

17. What is the purpose of ALLEXCEPT() in a DAX measure?

Removes all filters except specified columns

Excludes specific rows from calculation

Combines multiple filter conditions

Resets row context to table context

18. In DAX, RELATED() retrieves values from which direction in a relationship?

Many-to-many only

One side of a one-to-many relationship

Both directions

Reverse lookups only

19. Which function returns the year-to-date total in DAX?

TOTALYTD

YEARTODATE

DATESYTD

CUMULATIVE

20. What does the CALCULATE function primarily do in DAX?

Aggregates values in a column

Modifies filter context for an expression

Counts distinct values

Returns the average of a range

Fabric Analytics Engineer DAX Measures for Reporting Quiz

1. What does the HASONEVALUE() function check?

2.

What first name or nickname would you like us to use?

2. What is the primary advantage of using CALCULATE over nested IF statements in Fabric reports?

3. True or False: A measure defined on one table cannot be used in visuals based on another table.

4. Which function calculates a running total across a sorted axis?

5. What does USERELATIONSHIP() do in DAX?

6. True or False: Implicit measures are automatically created for numeric columns in Fabric.

7. Which function creates a table of dates between two dates?

8. What is the purpose of VALUES() in DAX?

9. True or False: SUMPRODUCT can be used to sum products of arrays in Fabric Analytics.

10. Which function returns blank if a condition is false in DAX?

11. Which DAX function calculates a sum across rows in a table without respecting filter context?

12. True or False: Filter context is automatically inherited by all measures on a report page.

13. Which function is used to compare current period with previous period in DAX?

14. What does DISTINCTCOUNT() return in DAX?

15. True or False: A measure in Fabric can reference columns from multiple tables without explicit relationships.

16. Which of the following is a row context function in DAX?

17. What is the purpose of ALLEXCEPT() in a DAX measure?

18. In DAX, RELATED() retrieves values from which direction in a relationship?

19. Which function returns the year-to-date total in DAX?

20. What does the CALCULATE function primarily do in DAX?