Hi ,
How are you
doing?
One quick question for you!
The Sales table contains a currency code
column. Based on that, I’d like to count how many unique brands (from the
Brands column in the Products table) were sold.
Question
for you – which of the following measures calculates the correct
result?
A = DISTINCTCOUNT ( Products[Brands] )
B = VALUES ( Products[Brands] )
C = COUNTROWS ( Products )
D = CALCULATE ( DISTINCTCOUNT ( Products[Brands] ), Sales )
E = CALCULATE ( DISTINCTCOUNT ( Products[Brands] ) )
Don’t scroll.
Keep the answer in your head.
Let's see if you get this one right!