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 using the count Function
B. By creating a derived measure on the logical column item number and using the count distinct function
C. By creating a derived measure based on the physical column item number and changing the aggregation method to count
D. By creating a derived metric by using the Expression Builder