Return Week number based on best week sales

Hi Anonymous , try this:

Highest Week = 
var _maxSold= MAX(myTable[Total Sold]) // get the highest weekly sold

var _calc =CALCULATE(MAX(myTable[Week]),myTable[Total Sold]=_maxSold)

return _calc

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

Hi,

Try these measures:

Total sales = SUM(Data[Total sold])

Best selling week = FIRSTNONBLANK ( TOPN ( 1, VALUES ( Data[Week] ), [Total Sales] ), 1 )

Another way to achieve this...

Assuming the name of your table is Sales then try this...

Week with highest sale =
CONCATENATEX (
    TOPN (
        1,
        Sales,
        Sales[Total sold]
    ),
    Sales[Week],
    ", ",
    Sales[Total sold], DESC
)