TDA-C01 Exam - Question 119

Question

A Data Analyst has the following worksheet, with Profit data for Category and Sub-Category.

The analyst executed the following calculated field at the Total level.

COUNTD( IF { INCLUDE [Sub-Category]: SUM([Profit]) < 0 } THEN [Category] END )

What is the result?

Examice · Accepted Answer

janasuresh · Answer

Asking for Category: "Office Supplies" and "Furniture"

thea_ipynb69 · Answer

"Office Supplies" and "Furnitures has a sub-category with negative profit. Therefore, there are 2 distinct categories.

ShazzyHawk · Answer

Only first two categories meet the condition

Discussion