How to optimize loading when there is too much issue data?

Questions & Answers
1

Hi, gus~
Here is the filter that add the inspect time. There are too much issues with 27W+ and its couldn’t load. Now i want to narrow down issues through issue type. How should i do ?
Sum(
Filter(
Descendants([Issue].Currentmember, [Issue].[Issue]),
DateInPeriod(
Format([Issue].CurrentHierarchyMember.get(‘to inspect time’),‘yyyy-MM-dd’),
[Time].[Year].CurrentDateMember
))
,
[Measures].[Issues created]
)

2

Hi,

If your intention is to show issues by inspect time, you can select to import this date field as a measure. That will create a standard measure that will work very fast: Issues with to inspect time.
The formula should look like this:

([Measures].[Issues with to inspect time],
[Time].[Year].CurrentDateMember)

Kindly,

1 Like