Measure from calculated column

[Anonymous]

Hi,

I have a calculated column and i want to create a measure on below condion.

measure= If (Calculated colum)=0, 0 , Calulated column/Totalsales.

Total sales is a measure. 

How can i achieve this?

Please help.

Thanks,

Paruchuri

[rafaelmpsantos]

measure= If (Sum([Calculated colum])=0, 0 , DIVIDE(SUM([Calulated column])/[Totalsales])

[TomMartens · Accepted solution]

Hey,

basically you have to consider that there is something called Evaluation Context, this context has two aspects: Filter Context and Row Context.

Whenever you create a measure you have to consider the Filter Context (at least). Another thing that you to be aware of is the fact, that a calculated column is aggregated, by default the SUM aggregation function is used for numerical values.

Maybe this may work

 a measure = 
var valueFromCalculatedColumn = CALCULATE(SUM('table'[calc column]))
return
IF(valueFromCalculatedColumn = 0
    ,0
    ,DIVIDE(valueFromCalculatedColumn,[Totalsales], BLANK())
)

Hopefully this is what you are looking for

Regards,

Tom