There is a logical fact table that contains Item number, store, time, and revenue. How would
you add Number of items sold?
A.
By creating a derived measure on the logical column item number and usingthe count
distinct function
B.
By creating a derived measure based on the physical column item number and changing
theaggregation method to count
C.
By creating a derived measure on the logical columnItem number and using the count
Function
D.
By creatinga derived metric by using the Expression Builder
A) and B)
As far as i understand.
Derived measure is based on logical model, so it cannot be B.
I’m not sure about “distinct” because item number sounds like some model number, not piece of item.
The argument for distinct is that there can be many rows in fact table connected with one sale.
I would go for C.
I have messed up metrics with measures.
I think it’s B