How to remove the error: 60 sec

Hello,

I try to have a table for defect management.

Intention is to be able to get for a selected period (in page) the number of issues of type defects.
I also want to create user defined measure to get the number of issues of type defects for the previous period and a calculated measure for the difference between the 2.

The issue I encountered is that the query takes more than 60 sec.

Here the code of the calculate measure:

NonZero(Count(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Issues created]>0
AND
[Measures].[Issue type]=“Defect”
)
))

Can someone help me with the issue?

Hello @Fabrizio,

Welcome to the eazyBI community!

​The current expression iterates through the Issue dimension and checks each issue separately.
However, the main benefit of the reporting system is the option to use aggregated values over categories of issues.

​Instead of counting individual issues and checking their relevance, you might address the relevant issue category via tuple.
Please read more about tuples here - Tuple.

​The same could be achieved via the following expression that retrieves values aggregated already during the data import.

([Measures].[Issues created],
 [Issue Type].[Defect])


Regards,
​Oskars / support@eazyBI.com

Thank you @oskars.laganovskis