9 Replies Latest reply: May 20, 2016 2:39 PM by Randy Belknap RSS

    Set Modifer not working as I thought it would when placed in a table

    Randy Belknap

      (See the attached sample)

       

      I've created a Measure using the {1} set modifer that is the average score of the entire data set (i.e. doesn't vary with selections.)  If I display that measure in a KPI, it works as I expected - it always shows the same value regardless of the selections.  However, if I put that measure in a table with the data, it ignores the set modifier.  Is there a way to put it in a table so it keeps the same value it shows outside of the table? 

       

      A more complicated case is using a set modifier to get an average score that is sensitive to the year {$<Person = >}, but not the person. i.e. it is the average score for the year or years selected.  Again in a KPI it does what I want, but in a table it gets ignored.

       

      The attached is a simplified version of the data.