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

Hi Pete,

 

Thanks for the reply. Yes the formula is correct however I am calculating margin % for different years. When i compute a line graph, my margin for both years has been combine which I wanted to split into different years for comparison.

 

I am able to margin % for LY with sameperiodlastyear formula but this year margin is the total margin for both years. How do I get marign for this year?