Forum Discussion
Anonymous
7 years agoNot applicable
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...
- 7 years ago
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
rafaelmpsantos
7 years agoResponsive Resident
measure= If (Sum([Calculated colum])=0, 0 , DIVIDE(SUM([Calulated column])/[Totalsales])