Can anyone explain how to even comprehend what the visual would look like for a question like this?

[YoungLearning]

What is the answer? This is an extremely weird question.

[Anonymous · Accepted solution]

Thanks for the reply from lbendlin , please allow me to provide another insight: 
Hi  @YoungLearning ,

I created some data:

Using the Sum() function will add all the data in the column, when used as a table visual, it will be based on the existence of columns in the table to group the sum.

For example

This visual has [Year] and [Total Population], then [Total Population] will be grouped according to [Year].

There are [Group] and [Total Population] in this visual, then [Total Population] will be summed up according to [Group].

2023 Population = CALCULATE([Total Population],'DateTable'[Year]=2023) The full code for this function is calculate(([Total Population],filter(all('DateTable'[Year]'),'DateTable'[Year]=2023), the all function ignores the ' DateTable'[Year], so it returns the same value.

You can use the following function if you want to achieve an answer of C:

FILTER is an iterative function that passes a range of specific values from specific tables and columns. at which point a pro-forma table is created in the value context containing the row with 'DateTable'[Year]=2023 and the other two rows stacked as empty without counting values;

FILTER function (DAX) - DAX | Microsoft Learn

powerbi - DAX Calculate function with and without FILTER - Stack Overflow

Avoid using FILTER as a filter argument in DAX - DAX | Microsoft Learn

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[lbendlin]

What have you tried? Have you created these tables and measures, and evaluated the result for yourself?

The correct answer is D. Note that in your screenshot there are calculated columns. The ask was for measures.

[YoungLearning]

Yes, I tried that again and realised it was measures. But how would you visualise without trying on PowerBI?

[lbendlin]

During the actual exam you would take a note of your knowledge gap and move on to the next question.