Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Calculated column

Greetings,   Tables:   2016 Rebate 2017 Rebate sales   I have this this Calculated column:   Rebate 2016b = CALCULATE( SUMx( Filter( sales, sales[year]=2016), sales[Rebatable]*related(...
Need Help
  • DAX0110's avatar
    DAX0110
    8 years ago

    Hi Anonymous,

     

    I'd suggest one of two ways to work around this error:

     

    (1) rewrite the calculated columns to remove the CALCULATE:

       Rebate 2016b = IF( sales[year]=2016,  sales[Rebatable] * related('2016 Rebate'[Percent%]) )

       Rebate 2017b = IF( sales[year]=2017,  sales[Rebatable] * related('2017 Rebate'[Percent%]) )

    , or

    (2)  remove these calculated columns from the Sales table and change them into measures.

     

     

     

     

DAX0110's avatar
DAX0110
Resolver V
8 years ago

Hi Anonymous,

 

I'd suggest one of two ways to work around this error:

 

(1) rewrite the calculated columns to remove the CALCULATE:

   Rebate 2016b = IF( sales[year]=2016,  sales[Rebatable] * related('2016 Rebate'[Percent%]) )

   Rebate 2017b = IF( sales[year]=2017,  sales[Rebatable] * related('2017 Rebate'[Percent%]) )

, or

(2)  remove these calculated columns from the Sales table and change them into measures.

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thank you - lots to learn, often quoted

     

    "DAX is simple, but it is not easy!"

     

    Best