Answer-first summary for fast verification
Answer: EVALUATE SUMMARIZECOLUMNS('Customers'[Country], "NumberOfCustomers", COUNT('Customers'[CustomerID]))
Option A correctly counts the number of customers in each country. Options B, C, and D either count by the wrong column or do not group by the country correctly.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Consider a scenario where you need to connect to and query datasets using the XMLA endpoint in Fabric. You have a tabular model with a table named 'Customers' that contains columns 'CustomerID', 'FirstName', 'LastName', and 'Country'. Write a DAX query to find the number of customers in each country. How would you structure this query?
A
EVALUATE SUMMARIZECOLUMNS('Customers'[Country], "NumberOfCustomers", COUNT('Customers'[CustomerID]))
B
EVALUATE SUMMARIZECOLUMNS('Customers'[Country], "NumberOfCustomers", COUNT('Customers'[FirstName]))
C
EVALUATE SUMMARIZECOLUMNS('Customers'[Country], "NumberOfCustomers", COUNT('Customers'[LastName]))
D
EVALUATE SUMMARIZECOLUMNS('Customers'[Country], "NumberOfCustomers", COUNT('Customers'[CustomerID]))
No comments yet.