Measure not working?

[Anonymous]

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

[isjoycewang · Accepted solution]

Hi @Anonymous,

Please refer to MAX Intro article: https://learn.microsoft.com/en-us/dax/max-function-dax

MAX() only references a column. If you want to use MAX(), a quick workaround might be to transform your measure to a calcualated column.

Best Regards,

Joyce