Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |