Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Absolute referencing - Fixed value in a measure.

Hi,  I wish to have a value fixed in the measure called "measure 3". The measure 3 calculation is given in formula bar in the screenshot 1 and below as well. The user right now is comparing season...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, thank you your response. There seems to be an error occuring when I upload the sample data set table in here. If you can provide me your email, I can sent the sample data set immediately.

 

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      4 years ago

      yes, thank you.  While I look at it please read about ALLEXCEPT and REMOVEFILTERS.  These will allow your to calculate "fixed"  measures that are only impacted by some filters but not by all.