What does "filter context" mean in DAX?

The current selection or filters applied in a report

What does the CALCULATE() function do?

Changes the filter context for an expression

Why is DIVIDE() used instead of the / operator in DAX?

It avoids division by zero errors

What is the role of ALLEXCEPT()?

Removes all filters except for specified columns

What is the main difference between a calculated column and a measure?

Calculated columns are static; measures are dynamic

When should you use a calculated column instead of a measure?

When you need a value stored per row

What is RELATED() used for?

Fetching a value from a related table

What does a measure return?

A single result based on the current filter context

. What is the main use of TOTALYTD()?

Add up values from the start of the year to now

What does SAMEPERIODLASTYEAR() return?

Values from the same period in the previous year

studbud

Practice Week 5

13 termsStudBud Administration15 plays

Imported from external platform

Flashcards13 cardsFPractice quizPHost liveL

Questions 13

Answers

1
What does "filter context" mean in DAX?
The rules used to import data
The current selection or filters applied in a report
The number of rows in a table
The number of filters in the model
2
What does the CALCULATE() function do?
Converts text to numbers
Performs multiplication
Changes the filter context for an expression
Creates a filter relationship
3
Why is DIVIDE() used instead of the / operator in DAX?
It's shorter to write
It avoids division by zero errors
It automatically formats results
It prevents blank values
4
What is the role of ALLEXCEPT()?
Adds new relationships between columns
Filters only selected rows
Removes all filters except for specified columns
Applies all filters in a table
5
What is the main difference between a calculated column and a measure?
Measures are saved in Excel, calculated columns are not
Measures are used only for text
Calculated columns update in real time with slicers
Calculated columns are static; measures are dynamic
6
What kind of calculations are considered Time Intelligence?
Data types and formats
Comparing values over time
Grouping rows into categories
Sorting rows alphabetically
7
When should you use a calculated column instead of a measure?
When your column contains time intelligence
When you use slicers
When you want a dynamic total
When you need a value stored per row
8
What is RELATED() used for?
Creating relationships manually
Formatting text
Importing external data
Fetching a value from a related table
9
Which DAX function is most often used to define custom aggregations?
FORMAT()
CALCULATE()
SWITCH()
LEN()
10
I was on lectures on Monday and Wednesday
no :(
yes :)
11
What does a measure return?
A filter table
A single result based on the current filter context
A value for every row
A relationship between two tables
12
. What is the main use of TOTALYTD()?
Return only values with errors
Filter rows that are not blank
Show data for the last 7 days
Add up values from the start of the year to now
13
What does SAMEPERIODLASTYEAR() return?
Data from the beginning of time
Average of all periods
Values from the same period in the previous year
The first date in the dataset

Practice Week 5 Flashcards | StudBud