Obtain MAX of column and display for each row

[Anonymous]

Hi,

I'm trying to obtain the MAX of a particular column and place this as a new Measure within each ROW of the same dataset. Please see the example below:

Is this possible in DAX and via DirectQuery?

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may try the following measure.

Measure =
MAXX ( ALLSELECTED ( Table1 ), Table1[Value] )

[Anonymous]

Hi @Anonymous ,

you can use DAX.

Add new column. Max = MAX(Value)

Best regards

Timo

[Anonymous]

Hi Timo,

Thanks for the suggestion but this doesn't work with LiveConnection to a Tabular Model. 

When I use MAX in LiveConnection I receive the following error message:

The report measure MaxValue has a syntax or semantic error at line 1, position 6, reported by Analysis Services: 'Column, 'Value' in table XXX cannot be found or may not be used in this expression.

I know this could be added to the Tabular Model, but for reasons I'd rather not go into, this is unfortunately not possible.