Page filters ignored by report measure?

Questions & Answers
3

Hi @chrispy35

You’re right on with the “Measure is Treasure” mantra!

The dimension members in the report context (in Rows or in Page filters) adjust the measures used in the report, they don’t have an impact on the properties.

Since your first formula is filtering a set of issues by only a property, all results will be the same, no matter the report context.

However, when filtering a set of issues, it is recommended to filter by properties first, as in the database level they are in the same table as the issues, so it will have the best performance.

Here’s an optimized version of your formula:

Sum(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    NOT IsEmpty([Issue].CurrentMember.Get(<field name>))
  ),
  IIf(
    [Measures].[Issues created] > 0,
    1, 
    null
  )
)

​Best regards,
Nauris