Exam PL-300 topic 2 question 63 discussion

Wrong Tested, correct answer is Distinctcount('Product'[product category], 'sales'

This question was definitely on todays exam

I would vote for DISTINCTCOUNT('Sales'[ProductId]) and filter to be applied to 'Date' (distinct) counting the Product Category in the Product table would return '1' for each category as they are listed only once in that table, aren't they? so we should count (distinctcount) how many times they are listed in the 'Sales" table

The correct answer is DISTINCTCOUNT('Product'[ProductCategory]), 'Date'

Tested CategorySoldCount = CALCULATE( DISTINCTCOUNT(Products[ProductCategory]),Sales)

it has to be sales and not date because of the filter flow

Both Sales and Date passed as a calculate modifier seem unnecessary

The question is: the number of product categories that had products sold during a selected period. Tested with data from adventureWorks using: 1 report, 2 cards, 1 slicer card 1 has 'date' card 2 has 'sales' slicer is connected to Date table (using between dates parameters) Using 'Date' will always return all the distinct categories no matter the selected dates in the slicer. Using 'Sales' returns the number of distinct categories sold between the two dates of the slicer correct tested answer is: Distinctcount('Product'[product category], 'sales'

This is a terrible question but I am going to say the posted answer is corrected since there is no cross filter direction in the relationship or DAX to indicate that Sales should be filtered on. The date table has to be connected to the Sales table by the sales date and by using date to filter, you are not using a fact table to filter in the answer. Terrible question, but this is my best attempt to defend the posted answer.

correct answer is Distinctcount('Product'[product category], 'sales'

tested in PBI: Product Categories Sold = CALCULATE(DISTINCTCOUNT('Product'[ProductCategory]), Sales) will return count of categories sold per selected time period

Answer: CALCULATE(DISTINCTCOUNT('Product'[ProductCategory]), 'Sales') Explanation (my attempt): "to count num. of prod. categories" -> DISTINCTCOUNT('Product'[ProductCategory]) "had products sold" -> therefore, we want the filter to be the table sales, so that if a product ID is not found in sales table, then this ID's product category will not be counted in DISTINCTCOUNT "during a selected period" -> I think this means we can "select" the desired period from a slicer in the report's page, or in the **Filters** pane, so this filter will automatically propagate to this DAX formula.

Distinctcount('Product'[product category], 'Date'

I was wondering why it should be 'Sales,' not 'Date,' but here's chat GPT's explanation. Product Categories Sold = CALCULATE( DISTINCTCOUNT(Product[ProductCategory]), Date ) what this formula does: - It counts the distinct product categories from the 'Product' table. - The filter context is based on the 'Date' table, meaning the calculation will consider only the dates that are currently selected or visible in your report. In short, it has nothing to do with Sales, which is not what we want.

Distinctcount('Product'[product category], 'sales' For those saying Count, it cannot be count. Yes the words they use are give us the count of categories in this period. But they mean Distinct, it has too. If you have Categories A B C And selling stuff like A bike A chain B wheel There are only 2 categories. Now 3. If you do a count now you said 3... But there will never be 3 categories its 1 and 1 with a duplicate... = 2. And sales not Date, because date has a 1 - Many relationship with Sales. so if you do a count on Date, you could end up with more than you expected as it would include duplicate categories from sales to cover the dates of those sales.

The answer should be: Distinctcount('Product'[product category], 'sales' as the question clearly states: product categories that had products sold during a "selected period" so the period is already selected.

DISTINCTCOUNT ( 'Product' [ProductCategory] ), 'Sales' - Context Transition thanks to CALCULATE