Solved: Explain this measure

M2M · ‎04-21-2018

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 · ‎04-24-2018

@M2M,

This is caused by duplicate records.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎04-24-2018

@M2M,

This is caused by duplicate records.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler · ‎04-21-2018

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

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

M2M · ‎04-21-2018

Sorry about that.

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

Interkoubess · ‎04-21-2018

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 · ‎04-21-2018

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.

Explain this measure

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly