Solved: Re: Obtain MAX of column and display for each row

Anonymous · ‎03-12-2019

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 · ‎03-25-2019

@Anonymous ,

You may try the following measure.

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

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 · ‎03-25-2019

@Anonymous ,

You may try the following measure.

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

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.

Anonymous · ‎03-12-2019

Hi @Anonymous ,

you can use DAX.

Add new column. Max = MAX(Value)

Best regards

Timo

Anonymous · ‎03-12-2019

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.