Forum Discussion

lcerrapa's avatar
lcerrapa
Helper I
9 years ago
Solved

Problem with IF(VALUES(Calendar[MONTHCODE])) What is happening?

Hello all.   I wasted several hours in this calculations with no results for me. The final (and wrong, I think) results I got are the following:     I have two main measures, one for real ...
Need Help
  • mattbrice's avatar
    mattbrice
    9 years ago

    While it is hard to say without being very familiar with your info, it looks to me  like the issue is in the LCP_ForecastVariation measure.   I would look at how the [LCP_FixedValue] and [Month Production] measures are calculated - does adding the Calendario[Ano] column to their filter context alter their values?  

     

    And also from what i can see in the LCP_RealVariation measure, the line :  FILTER(Calendario; Calendario[MONTHCODE]<=[mesReal] is going to be in contrast to the LCP_VarExMp_Test3 second IF statement causing a blank result.

     

    My first ideas...

mattbrice's avatar
mattbrice
Solution Sage
9 years ago

While it is hard to say without being very familiar with your info, it looks to me  like the issue is in the LCP_ForecastVariation measure.   I would look at how the [LCP_FixedValue] and [Month Production] measures are calculated - does adding the Calendario[Ano] column to their filter context alter their values?  

 

And also from what i can see in the LCP_RealVariation measure, the line :  FILTER(Calendario; Calendario[MONTHCODE]<=[mesReal] is going to be in contrast to the LCP_VarExMp_Test3 second IF statement causing a blank result.

 

My first ideas...

lcerrapa's avatar
lcerrapa
Helper I
9 years ago

Hello mattbrice

 

I deleted all the measures and I wrote all it again. There was an error on a measure that affects all dependent measures (and I don't found it). Now it's working.

 

Many thanks for your time.