Explain this measure

[M2M]

I am new to DAX so please forgive if the question is a bit pueril  .Can anyone please explain what is happening in the screenshot marked in red ?Cannot get my head around it.

The measure forumla is : Measure = MAXX(Sales,CALCULATE(SUM(Sales[Sales$])))

[v-chuncz-msft · Accepted solution]

@M2M,

This is caused by duplicate records.

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[M2M]

Sorry about that.

I have uploaded the pbix file here : https://ufile.io/2jrpw

[Interkoubess]

Hi @M2M,

What is your main goal with this measure?

What do you want to have?

You can give more data and I may try to help.

Ninter

[M2M]

Hello ,

There is no specific requirements as such.Just that while playing around with DAX I stumbled across this behavior.I will post some sample data after sometime.But you can create the data using the ones I have posted on the screenshot.