Forum Discussion
Compare a single client performance versus a the segment performance
Hello Everyone,
I would like to find the best way to compare a client performance versus a particular segment it is part of. For example: When consulting a specific tour operator, it should bring t...
phgatto , Measure
Client rev = sum(Table[Revenue] )
Client rev Segment= calculate(sum(Table[Revenue] ), filter(allselected(Table), Table[Segment] = max(Table[Segment]) ) )
% = divide([Client rev], [Client rev Segment] )
or
% = divide([Client rev], [Client rev Segment]- [Client rev] )
Good Evening amitchandak
Unfortunately this isn't the solution that I'm looking for.