Hi,
i have made a simple dax calculation which presents the New Customers:
New Customers = IF([LY Sales LC]>0,BLANK(),IF([Sales LC]>0,[Sales LC],BLANK()))
i am making a pivot with customer in the row and get the new customers list with sales.
My question is how to get the number of New Customers (Distinct Count) and Total Sales(Sum) based on the population received by the original measure
thanks
[ one way is to create a calculated column that mark new customers but i guess there is a better way using a measure)
i have made a simple dax calculation which presents the New Customers:
New Customers = IF([LY Sales LC]>0,BLANK(),IF([Sales LC]>0,[Sales LC],BLANK()))
i am making a pivot with customer in the row and get the new customers list with sales.
My question is how to get the number of New Customers (Distinct Count) and Total Sales(Sum) based on the population received by the original measure
thanks
[ one way is to create a calculated column that mark new customers but i guess there is a better way using a measure)
Last edited: