Forum Discussion
max(MyMeasure) doesnt work...
I have my measure: DIVIDE ( SUM(Fact[Hours]) - CALCULATE (SUM( Fact[Hours2]) , ALL(Fact) , Fact[Type]="D" ), SUM(Fact[Hours]) ) It works fine. But now I want to use it i...
Hi Anonymous ,
As far as I know, you don't need to use MAX() to use a measure, you can use it directly in your code.
MAX() only support to use a column.
Measure = SUM(Fact[Hours]) * [MyMeasure]If you want to get MAX from the measure, you can try MAXX().
Measure = SUM ( Fact[Hours] ) * MAXX ( VALUES ( 'TableName'[KeyColumn] ), [MyMeasure] )Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
FreemanZ
Super User
Super UserMAX of mymeasure in which dimension?
I have a fake "Measures" table where I store all my measures.
(I created it using DATATABLE, this approach was recommended from sqlbi website)