doubt with DAX expression

[ania_roh]

Hello.

I´m learning Dax and there is one thing which I don´t understand. Could you help me to understand the reason of why the result of these expressions are like that?

If I use for example this expression, the result I obtain is what I want obtain

 (by the way, I understand that using “all” and “summarize” in this case has the same meaning, isn´t it?)

The problem is when I want to use expression instead of measure (sales amount) I mean:

Sales amount = sumx ( net price * quantity) like that:

The result is incorrect ( using “all” the same). The result is the sum of the all sales, for every row. Why is it like that if I put just the same expression in the measure?

Thank you in advance

[Jihwan_Kim]

Hi,

When you use a measure inside another measure, in some cases, for instance, if you use an iterator, it creates Context-Transition-Environment.

When you do not use a measure, but an expression, inside another measure, you may think whether or not to use CALCULATE function in front of your expression in order to create Context Transition when you are using together with an iterator.

In this case, instead of only writing an expression,

in front of SUMX, try to write CALCULATE( your expression ).

[ania_roh]

Thank you @Jihwan_Kim  for your quick answer. 
I didn´t exactly understand what you mean by "using a measure inside another measure" because I have here only one measure inside one table (summarize). 

Is it related with a row- contects ? How many row context I have here?

And also, do I understand good that in this case "all" and "summarize " have the same functions?  (There is no difference between them? ) 

Thank you a lot for your time 🙂 

[Jihwan_Kim · Accepted solution]

Hi,

Inside ADDCOLUMNS,

the first two examples are using the measure, [Sales Amount]

the last example is using the expression, SUMX( Sales, Sales[Price] * Sales[Quantity] )

Please try to use the below if you want to write an expression when creating a table.

Categories Table =
ADDCOLUMNS (
SUMMARIZE ( 'Product', 'Product'[Category], 'Product'[Subcategory] ),
"@sales", CALCULATE ( SUMX ( Sales, Sales[Price] * Sales[Quantity] ) )
)

Those two functions are different functions.

Sometimes, ALL and SUMMARIZE do the same job, sometimes do not.

My preference is writing like below. But it depends on the case.

Categories Table =
SUMMARIZECOLUMNS (
'Product'[Category],
'Product'[Subcategory],
"@sales", SUMX ( Sales, Sales[Price] * Sales[Quantity] )
)

[Fsciencetech]

Can you please sample pbix and also check once your datamodel.