Question
You have a Fabric tenant that contains a semantic model. The model contains data about retail stores.
You need to write a DAX query that will be executed by using the XMLA endpoint. The query must return a table of stores that have opened since December 1, 2023.
How should you complete the DAX expression? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all.
```
[Target 1]
VAR _SalesSince =
DATE ( 2023, 12, 01 )
[Target 2]
FILTER (
[Target 3] ( Store, Store[Name], Store[OpenDate] ),
Store[OpenDate] >= _SalesSince
)
```
Explanation
A DAX query that declares query-scoped variables starts with DEFINE, which holds the VAR _SalesSince definition. The table to return is produced by an EVALUATE statement, so EVALUATE goes before FILTER; without it the query returns nothing. Inside FILTER, SUMMARIZE (Store, Store[Name], Store[OpenDate]) builds a table of distinct store names and open dates, which FILTER then restricts to stores opened on or after December 1, 2023. FILTER cannot take a table plus column list in that form, and TABLE is not a DAX function that groups columns.
