Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • TomMartens's avatar
    TomMartens
    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

     

     

TomMartens's avatar
TomMartens
Super User
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