Return the Value of the Highest Month of Sales

[fva6937]

I need to find the best month of sales and return its value (for the max value of the gauge).

Anyone :)?

[Zubair_Muhammad · Accepted solution]

HI @fva6937

Try this Measure for Highest Month Value

HighestMonthValue =
MAXX (
    SUMMARIZE (
        TableName,
        TableName[Date].[Month],
        "Total Sales", SUM ( TableName[Sales] )
    ),
    [Total Sales]
)

[fva6937]

Thant's Awesome! Thanks!!

Is there a way that I could get the value by the Salesperson, when I filter?

I tried SUMX, but I still have more to learn 

[Zubair_Muhammad]

Hi @fva6937

Then use this MEASURE for Month with Highest Sales

HighestMonth =
VAR mytable =
    SUMMARIZE (
        TableName,
        TableName[Date].[Month],
        "Total Sales", SUM ( TableName[Sales] )
    )
VAR myValue = [HighestMonthValue]
RETURN
    CALCULATE (
        FIRSTNONBLANK ( TableName[Date].[Month], 1 ),
        FILTER ( mytable, [Total Sales] = myValue )
    )

[Zubair_Muhammad]

@fva6937