max sales for each product and for each month

[powerbiexpert22]

i want to show maximum sales for each product and for each month in below table. sample pbix is attached. the expected output for product "All - Purpose Bike Stand" should be 318 instead of 159. i tried below but it is not giving correct results 

https://drive.google.com/file/d/15fAZVG1YOSgVVn4R6kDZ5J-NEmCFMQMk/view?usp=drive_link

Highest sales value for any Product =

var last_date=max('Calendar'[Date])

RETURN

CALCULATE(

    MAX(FactInternetSales[SalesAmount]),

    FILTER(ALL('Calendar'[Date]),

    'Calendar'[Date]<=last_date),

     FILTER(ALL(DimProduct[ProductKey]),

    DimProduct[ProductKey]<=MAX(DimProduct[ProductKey])))

I want to show in below table

below is the sales distibution for each day in a month:

[v-ssriganesh]

Hello @powerbiexpert22,

We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.

Thank you.

[ribisht17]

hi @powerbiexpert22 

Max Sales per Product per Month =
CALCULATE(
MAXX(
SUMMARIZE(
FactInternetSales,
DimProduct[ProductName],
'Calendar'[Year],
'Calendar'[Month],
"MonthlySales", SUM(FactInternetSales[SalesAmount])
),
[MonthlySales]
)
)

Regards,

Ritesh

Community Champion

Please mark the answer if helpful so that it can help others

Dance-Sing with Data -BI & Analytics

[Ashish_Mathur]

Hi,

Write these measures

Sales = SUM(FactInternetSales[SalesAmount])

Max sales = maxx(VALUES('Calendar'[Date]),[Sales])

Hope this helps.

[v-ssriganesh]

Hello @powerbiexpert22,

Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.

Thank you.

[v-ssriganesh]

Hi @powerbiexpert22,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @amitchandak for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

Thank you for being part of the Microsoft Fabric Community.

[amitchandak · Accepted solution]

@powerbiexpert22 , check this, I have forced a day level sum and then max 

Highest sales value for any Product = 
var last_date=max('Calendar'[Date])
RETURN
CALCULATE(
    Maxx(SUMMARIZE(FactInternetSales, 'Calendar'[Year],'Calendar'[MonthNo], 'Calendar'[Date], DimProduct[ProductKey], "_1", CALCULATE(Sum(FactInternetSales[SalesAmount]))), [_1]),
    FILTER(ALL('Calendar'[Date]),
    'Calendar'[Date]<=last_date),
     FILTER(ALL(DimProduct[ProductKey]),
    DimProduct[ProductKey]=MAX(DimProduct[ProductKey])))