4 Measures Flashcards
What are measures in Power BI?
Calculated values derived from existing data, not physical columns in the table.
What is the primary purpose of measures in Power BI?
Used in visualizations to display aggregated values and insights.
What is the first step in creating a measure in Power BI?
Select ‘New Measure.’
What should you do after selecting ‘New Measure’?
Name the measure (e.g., ‘Total Sales’).
What is an example of a DAX formula for a measure?
SUM(Sales[Sales Amount]).
In what types of visualizations are measures primarily used?
Charts and graphs.
What is filter context in the context of measures?
Filters applied in the report, slicers, or within the DAX formula itself.
What is row context in relation to measures?
The current row in a table when used in a calculated column; measures don’t have row context by themselves.
Name three aggregation functions used in measures.
SUMAVERAGECOUNT
What are DAX functions used for in measures?
Measures can utilize a wide range of DAX functions beyond aggregation, including logical, mathematical, text, and date functions.
What are iterators in DAX functions?
Functions like SUMX, AVERAGEX that go through each row in a table and perform calculations.
How do measures behave in relation to changes in data or filters?
Measures are dynamic; they recalculate based on changes in data or filters.
Why is efficient DAX formula writing important?
Crucial for optimal report performance.
What features does the DAX editor in Power BI Desktop provide?
- IntelliSense
- Syntax highlighting
- Formula validation
List two use cases for measures.
- Calculating KPIs
- Tracking trends
True or False: Measures can be static and do not change with data updates.
False.
Fill in the blank: Measures are primarily used in _______.
visualizations.
