topic Re: max(MyMeasure) doesnt work... in DAX Commands and Tips

max(MyMeasure) doesnt work...

Anonymous — Wed, 15 Nov 2023 12:05:11 GMT

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)?

FreemanZ — Wed, 15 Nov 2023 12:44:54 GMT

MAX of mymeasure in which dimension?

Anonymous — Wed, 15 Nov 2023 13:48:30 GMT

I have a fake "Measures" table where I store all my measures.

(I created it using DATATABLE, this approach was recommended from sqlbi website)

Anonymous — Tue, 21 Nov 2023 06:06:39 GMT

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 Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.