dax example

[Bakhtawar]

i want examples of these points .. 

• Any DAX function always refers to a complete column/field or a table. It will never refer to individual values. If you want to use the functions on separate values within a column, you need to apply filters in a DAX formula.
• DAX functions provide the flexibility to create a formula that is applied on a row-by-row basis. The calculations or formulas get applied as per the context of the values in each row.

any example please?

[Greg_Deckler · Accepted solution]

So, an example of the first one, to get to an individual value of a cell you could do something like this:

Measure = MAXX(FILTER('Table',[Column] = "Something"),[Value])

This would filter the table "Table" to only the rows where "Column" equals the value "Something" and then return the maximum value in the Value column from that subset. Note, there are literally tens of thousands if not hundreds of thousands of examples that could be provided for this because it is how DAX works. It is a core concept and I include it in my book in the first chapter "Thinking DAX".

Correct, this would be a calculated column like:

New Column = [Column1] + [Column2]

Each row would take the value in Column1 and Column2 for that row and add them together into the new column, "New Column".

Or, in a measure, you can use ADDCOLUMNS and it's the same sort of thing.

[Greg_Deckler · Accepted solution]

So, an example of the first one, to get to an individual value of a cell you could do something like this:

Measure = MAXX(FILTER('Table',[Column] = "Something"),[Value])

This would filter the table "Table" to only the rows where "Column" equals the value "Something" and then return the maximum value in the Value column from that subset. Note, there are literally tens of thousands if not hundreds of thousands of examples that could be provided for this because it is how DAX works. It is a core concept and I include it in my book in the first chapter "Thinking DAX".

Correct, this would be a calculated column like:

New Column = [Column1] + [Column2]

Each row would take the value in Column1 and Column2 for that row and add them together into the new column, "New Column".

Or, in a measure, you can use ADDCOLUMNS and it's the same sort of thing.

[Bakhtawar]

and second one ?

[v-eachen-msft · Accepted solution]

Hi @Bakhtawar ,

Here is the test data.

Then I created a measure:

Measure = 
SUM('Table'[Column3])

Now you could do see the different results with column1 and column2.

The measure will show different result depends on your context.