Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Unchanged value

One of my x table is connected to calender table. I am calculating avg (x[value]) but I dont want this to change according to the date through out my report. I cannot change my connection with the...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    If I'm understanding your question correctly, you can update your measure from AVERAGE ( x[value] ) to

    CALCULATE ( AVERAGE ( x[value] ), ALL ( CalendarTable ) )

    This removes any filtering from CalendarTable.

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

If I'm understanding your question correctly, you can update your measure from AVERAGE ( x[value] ) to

CALCULATE ( AVERAGE ( x[value] ), ALL ( CalendarTable ) )

This removes any filtering from CalendarTable.