I create a report but dimensions do not seem to limit the measures

Usually when I build a report, I assign measures, dimensions and it limits the measures by the dimensions. This usually works fine. These reports are tables.

Lately, I have not been experiencing this. I’ve been working on a report for SLA Breaches, Time to Resolution breaches and assignee. As soon as I assign the measure of Issue Assignee, it goes from displaying the proper amount of tickets to displaying all tickets in the established time frame in my dimensions.

I just need to know who is assigned to the breached tickets, not who is assigned to all tickets for the preferred time period.

Is this expected behavior? Or is something wrong here?

Hi @Thomas_Cruz

Welcome to eazyBI Community and thanks for posting your question!

This may happen when applying Issue properties (such as Issue Assignee) in the report. To apply report context, apply a Row filter > 0 for your measure “Time to Resolution breaches” so that your Page filters are taken into account for the measure “Time to Resolution breaches”

Best wishes,

Elita from support@eazybi.com

That almost works. However, it doesn’t not allow the other column to reflect its data. Below is a screenshot of what we are working with. I need the rows with unnecessary empty data to be gone.

Hi @Thomas_Cruz

Thanks for the screenshot!

The simplest solution would be to define a new calculated measure using CASE statement that would act as a row filter. Then apply a row filter to be > 0 . Once the filter is applied you can remove this new measure from the report rows (the filter will remain active in the background)

CASE
WHEN
not IsEmpty([Measures].[First reply time - Breached]) THEN [Measures].[First reply time - Breached]
WHEN
not IsEmpty([Measures].[Time to resolution - Breached]) THEN [Measures].[Time to resolution - Breached]
END

Best wishes,

Elita from support@eazybi.com

I apologize for the confusion. But it is supposed to look like this with an assignee beside each row.

Once the issue assignee column is added in as a measure, it displays all tickets for the assigned time period (last week)

Below is an example of what we do not want it to look like:

For every row that has the number 1 next to it, there is supposed to be a name (user) in the Issue Assignee row. It is populating all tickets for the last week time period. When there is only supposed to be names next to the tickets with numbers next to them.

Hi @Thomas_Cruz

Thanks for the follow up!
Indeed, for that reason I suggested to define a new calculated formula which will act as a filter

Here is an example on my test data. I have almost the same measures as you do.
When I define a new calculated measure with the measure below


CASE
WHEN
not IsEmpty([Measures].[Time to first response - Breached]) THEN [Measures].[Time to first response - Breached]
WHEN
not IsEmpty([Measures].[Time to resolution - Breached]) THEN [Measures].[Time to resolution - Breached]
END

You will see it returns value 1 when one or the other measure is not empty

Then you can apply a row filter for this measure to be larger than 0

Once the filter is enabled, you can remove this measure from your report columns.

The filter will remain active in the background and you will not have any empty rows anymore

Best wishes,

Elita from support@eazybi.com