Find the Highest Potential Customer

[Anonymous]

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.

[Anonymous]

@Anonymous

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

[AlB]

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 

[Anonymous]

@AlB 

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

[AlB]

@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