Sum By Name Then Get The Min Value

[GlynMThomas]

Hi Guys,

How in power bi do I first sum my transactions by name to get the totals for each of my clients then get the min and max values?

I want to dynamically work out the who has spent the most and least in total over a period of time.

[v-yuta-msft]

@GlynMThomas ,

So your requirement is to achieve the max and min values of a measure in your senario, right? You could create two measures using dax below:

Max Values = 
MAXX (
    ADDCOLUMNS (
        SUMMARIZE (
            FILTER ( 'Table', 'Table'[Date] IN VALUES ( 'Table'[Date] ) ),
            'Table'[Client]
        ),
        "Total Per Client", CALCULATE ( SUM ( 'Table'[Sales] ) )
    ),
    [Total Per Client]
)

Min Values = 
MINX (
    ADDCOLUMNS (
        SUMMARIZE (
            FILTER ( 'Table', 'Table'[Date] IN VALUES ( 'Table'[Date] ) ),
            'Table'[Client]
        ),
        "Total Per Client", CALCULATE ( SUM ( 'Table'[Sales] ) )
    ),
    [Total Per Client]
)

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k · Accepted solution]

@GlynMThomas you can use MINX and MAXX function

Min Value = MINX( VALUES( Table[Clients] ), [Your Sum Measure] )

Max Value = MAXX( VALUES( Table[Clients] ), [Your Sum Measure] )