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