Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Division error - fields does not appear

Hi,   I have error with division in dax formula.   When using new measure : There is no numerator or denominator link to the fields.    When using quick measure, I could divide but is don...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Anonymous 
    You need to add an function to refer to a value when creating a measure. In your case, using sum, max, min or any other function does not change the result. And to get the current year margin%, you can create a measure with filter to today()'s year:

     

    Current Year Margin% = Calculate( [Margin%], Filter(Table, [Date].[Year]= Year(Today()))

     

     

    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Anonymous 
You need to add an function to refer to a value when creating a measure. In your case, using sum, max, min or any other function does not change the result. And to get the current year margin%, you can create a measure with filter to today()'s year:

 

Current Year Margin% = Calculate( [Margin%], Filter(Table, [Date].[Year]= Year(Today()))

 

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you Anonymous 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    I have tried using your formula for current year margin and it works. However, I tried to compute last year margin with sameperiodlastyear formula, the calculation i got is wrong. Do you know why?

     

    Regards,

    Sharene