How to select a value using SUMX or row context (to create a Measure)

[JustinDoh1]

I am trying to convert this Excel formula into measure.

=IF( D4>40, D4-40, 0 )  

I know, if I create in Column, it is pretty asimple process.

I am trying to save the disk space by creating a Measure.

This is initial approach:

Measure =

IF (

      sumx('Table1', Table1'[D4]) > 40,

     sumx('Table1',  Table1'[D4]) - 40,

0

)

I thought we could use SUMX as a row context, but I am not sure where I am missing.

Thanks for help.

[VahidDM · Accepted solution]

Hi @JustinDoh1 

If you want to apply this to all rows of D4 column, Try this:

Measure =

Var _Value = Max(Table1'[D4])
return
If(_Value>40,_Value-40,0)

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

Appreciate your Kudos✌️!!