We import a custom text field Office to EasyBI
[jira.customfield_10280] name = "Office" data_type = "string" dimension = true measure = false separate_table = false changes = true
The offices are pulled from Azure and have consistent values like
- Office 1
- Office 2
We create a custom measure Office
NonZero( Count( Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]), NOT IsEmpty([Measures].[Issue Office]) AND --measure to add context of the report [Measures].[Issues created] > 0 ) ) ) )
This works but is very slow und we get a lot of time outs. (we have around 130k tickets)
Query execution timeout of 60 seconds reached.
Please try to make query simpler.
What is a better way which works faster ?