Forum Discussion

nehajadhav166's avatar
nehajadhav166
Resolver I
4 years ago
Solved

Error with AverageX

Hi Experts,   I have created measure : Cpk = Var selected_Value=SELECTEDVALUE(TestData[Name]) Var selected_Char=SELECTEDVALUE(TestData[Characteristic.Name]) Var selected_maxdate=IF (ISFILTE...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi nehajadhav166 
    Calendar funtion works normally inside measures. You can also replace it with DATESBETWEEN and see if the result changes.

  • tamerj1's avatar
    tamerj1
    4 years ago

    nehajadhav166 
    I mean 

    && RFLoopback[Date] IN DATESBETWEEN ( RFLoopback[Date], selected_mindate, selected_maxdate )
nehajadhav166's avatar
nehajadhav166
Resolver I
4 years ago

tamerj1 , Error seems to be gone but I dont get correct calculeted value for Cpk.

Looks like caldender function not considering date range. If I user calender function seperatly as measure I get similar error as above.

Do I have to conver any column/value?

 

Thanks,

Neha

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi nehajadhav166 
Calendar funtion works normally inside measures. You can also replace it with DATESBETWEEN and see if the result changes.