Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to Solution.
@Anonymous ,
You may try the following measure.
Measure = MAXX ( ALLSELECTED ( Table1 ), Table1[Value] )
@Anonymous ,
You may try the following measure.
Measure = MAXX ( ALLSELECTED ( Table1 ), Table1[Value] )
Hi @Anonymous ,
you can use DAX.
Add new column. Max = MAX(Value)
Best regards
Timo
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.
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
69 | |
62 | |
55 |