locked
Using a measure as a filter RRS feed

  • Question

  • I created a measure to sum the total square footage used by an event.  What I want to do is count only those Events with a SUM Square Feet of 100,000 or more.

    I tried to use that Measure in a Calculate statement but it just counts everything whether it meets the criteria or not.  Is there a way to use the first measure in the second measure?

    Thanks.


    Rob

    Wednesday, April 1, 2020 8:11 PM

Answers

  • I figured out how to make it work.  I think I may have been thinking about it wrong by including the Event Name because I really just wanted a count by Fiscal Year and Month.  I removed the Event Name from the Pivot Table, and changed the Measure to this.

    This yielded the results I was looking for.

    Thursday, April 2, 2020 3:31 PM