Microsoft Power BI Data Analyst — Question 28
You have a Power BI model that contains two tables named Population and Date.
The Population table contains two columns named PopulationAmount and DateKey.
DateKey contains date values that represent the first day of a year and are used to create a many-to-one relationship with the Date table.
The Power BI model contains two measures that have the following definitions.
Total Population = Sum(‘Population’[PopulationAmount])
2023 Population = CALCULATE([Total Population], ‘Date'[Year] = 2023)
You create a table visual that displays Date[Year] and [2023 Population].
What will the table visual show?
Answer options
- A. one row per year that contains blank values for every year except 2023
- B. one row per date that contains the population value for the corresponding year repeated in each row
- C. a single row for the year 2023 that contains the related population value
- D. one row per year that contains the same value repeated for each year
Correct answer: D
Explanation
The correct answer is D because the measure [2023 Population] is calculated based on the total population for the year 2023, and since the relationship is many-to-one, the same value will be repeated for each year in the visual. The other options do not accurately reflect how the measure interacts with the Date table and the applied filter context.