Calculating Customer Status

[Jmccoy]

I have a table with customers, job name, and tot sell. The customer can show up multiple times depending on how many projects that have done with our company. I am looking to make a measure to show if the customer is existing or new. IF the customer shows up once in the column, they would be new. Otherwise the would be existing. 

[v-xuding-msft · Accepted solution]

Hi @Jmccoy ,

I created a simple sample that you could try.

Measure = 
var count_customers = CALCULATE(COUNTROWS('Table'),ALLSELECTED('Table'[Total sales]))
return
IF(count_customers = 1, "New","Existing")

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.