topic Re: Find the Highest Potential Customer in DAX Commands and Tips

Find the Highest Potential Customer

Anonymous — Tue, 20 Oct 2020 14:34:52 GMT

Hi,

I'm trying to find the most valueable customer who is lost.

For example, I'm caluculating the Lost Customer using the below dax.

IF([Last Booking Day Duration]>180,1,0). So if a customer has not placed for the past 180 days will be considered as a lost customer. Now I want to get the name of the customer who was giving highest revenue out of that lost customer list.

Thanks in advance.

Re: Find the Highest Potential Customer

AlB — Tue, 20 Oct 2020 18:46:43 GMT

Hi Anonymous

Please always show a sample of youra data. Otherwise we have to invent names of columns, make assumptions, ask questions and it's an unnecessary waste of everybody's time.

You can create a measure and place it in a card visual. Along the lines of:

HighestPotentialName = VAR highestRevenue_ = CALCULATE ( MAX ( Table1[Revenue] ), Table1[Last Booking Day Duration] > 180 ) RETURN CALCULATE ( DISTINCT ( Table1[Name] ), Table[Revenue] = highestRevenue_, Table1[Last Booking Day Duration] > 180 )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers

Re: Find the Highest Potential Customer

Anonymous — Wed, 21 Oct 2020 10:54:31 GMT

AlB

Your formula has the potential to return an error if there is more than 1 customer with the same characteristics.

Re: Find the Highest Potential Customer

Anonymous — Wed, 21 Oct 2020 10:53:56 GMT

Anonymous

What happens if there is more than 1 customer that satisfies the condition?

Re: Find the Highest Potential Customer

AlB — Wed, 21 Oct 2020 10:55:52 GMT

Anonymous

Yeah, that's by design. So that the user is alerted if that is the case. They can then decide how to deal with those cases.

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers