How do you limit a group of tuples to distinct issues?

Questions & Answers
1

I’m able to get down to almost the unique list of issues I want to report on. Either of these calculated measures will produce the same results:

 (
  [Measures].[Transitions to status issues count],
  [Transition Status].[In Progress],
  [Issue Type].[Advisement]
 )
 +
 (
  [Measures].[Transitions to status issues count],
  [Transition Status].[Ready for Review],
  [Issue Type].[Advisement]
 )

or

Aggregate(
 {
  [Transition Status].[Ready for Review],
  [Transition Status].[In Progress]
 },
 (
  [Measures].[Transitions to status issues count],
  [Issue Type].[Advisement]
 )
)

But, I cannot figure out how to reduce the count to distinct issues. Drilling into the issues shows that some issues are getting counted twice:

Screen Shot 2021-09-13 at 11.52.11 AM
Screen Shot 2021-09-13 at 11.52.11 AM2186×1480 413 KB

The drill through shows that there are 107 distinct issues. That is the actual number I want to have calculated so I can use it in another report.

2

Hi @lartra,

You are on the right track by using Aggregate(…) and Tuples, but you should do this in a slightly different way for correct execution order:

  1. Create the Aggregated Transition status member in the Transition Status dimension, named e.g. “Ready for Review and In Progress”:
Aggregate({
  [Transition Status].[Ready for Review],
  [Transition Status].[In Progress]
 })
  1. Reference this calculated member from Transition status in the tuple:
(
  [Measures].[Transitions to status issues count],
  [Transition Status].[Ready for Review and In Progress],
  [Issue Type].[Advisement]
)

Lauma / support@eazybi.com

1 Like
3

That works perfectly. Thank you!

1 Like