Forum Discussion
Measure from calculated column
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
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
2 Replies
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
measure= If (Sum([Calculated colum])=0, 0 , DIVIDE(SUM([Calulated column])/[Totalsales])
