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 calender table because of some other calculation. 
It's an easy query and I am clearly missing something. Can someone help? I tried using filter option but didn't work. 

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.

1 Reply

  • 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.