sum of max values by date/client

[SuperSayan]

Hi Everyone,

I looked onto the forum but didn't find exactly what I'm trying to achieve.

I have a long table of intervention done by technicians with date, client reference etc.

Each intervention has a price.

I have created the measure that allows me to sum the prices and divide it by the number of days where the technician has made at least 1 intervention.

However, the last step for me is to count only the highest price by day by client reference. Indeed, when a technician goes to 1 client and does 2 or 3 interventions at the same time, I want to count only the highest price in my calculation.

[v-ljerr-msft · Accepted solution]

Hi @SuperSayan,

Could post your table structures(including the measures you're using) with some sample/mock data, and the expected result against it? So that we can better assist on this issue. 

Regards

[v-ljerr-msft · Accepted solution]

Hi @SuperSayan,

Could post your table structures(including the measures you're using) with some sample/mock data, and the expected result against it? So that we can better assist on this issue. 

Regards

[SuperSayan · Accepted solution]

Hi,

I don't understand why but this post has been duplicated.

The other version of the post was closed after the answer was given, see below.
http://community.powerbi.com/t5/Desktop/sum-of-max-values-by-date-client/m-p/247337

I therefore close this thread as it has been solved somewhere else.

[Ashish_Mathur]

Hi,

Share the link from where we can download your file.  Also, show the expected result.

[CahabaData]

Your post is unclear.

If the data you provide is the starting data set - please state an example of the result you seek (not just a description/definition).

If the data you provide is the result you seek - please provide a sample of the starting data set.