Check if issue is filtered in report view

Questions & Answers
1

Hello,

I can’t find any information about this short question. If it is possible in calculated member/measure check if issue, project or etc. is filtered in report view (on “Pages” section)?

I would like to have something like this:
Sum(Filter(
** Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),**
** “Issues that are visible/filtered/shown in a current report” **
), [Measures].[“My own calculated measure”])

Thank you in advance,
Vladimir

2

You can use some measure as a filter. Measure Issues created is the most common filter used in those formulas. However, you might check if the context is correct when you are using this measure.

Measure Issues created will check all issues by issue creation date if Time is used in the report. It might not work with worklog and historical dimensions, though.

Sum(Filter(
 Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
  [Measures].[Issues created] > 0), 
  [Measures].[“My own calculated measure”]
)

For performance, we suggest using additional filters with issue properties before the common filter by measure. However, it might depend on some use cases.

Daina / support@eazybi.com