Forum Discussion
when to use count instead of DistinctCount?
I am doing a quick course on DAX in datacamp... they have created this measure: Transaction count = Count([FactInternetSale[SalesOrderNumber]) And then using it to do: Average Transaction = DIV...
no se usa CountDistinct, ya que solo se estaria contando los campos distintos del campo [Transaction Count]),
el promedio se toma de la sumatoria de los datos y se divide en la cantidad de datos. sin importar que sean iguales