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 in another measure to do:
SUM(Fact[Hours]) * MAX(MyMeasure)
And it doesn’t work… Why can't I do MAX(MyMeasure)?
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.
3 Replies
MAX of mymeasure in which dimension?
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.
