Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
@AlB
Your formula has the potential to return an error if there is more than 1 customer with the same characteristics.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |