How to apply column filter without losing the group

How can I apply a filter on this column, without losing the group “all issues” or “B2B” (since it has a sum and i use that sum as a gauge)

In this case, i can no longer display as gauge:

Hi,

If you want to count resolved issues before Jan 28 2021 in the report in separate column, you could create a new user-defined calculated measure
Then select it for your report and report would give you a counter of issues with the condition instead of returning a date for each issue.
Try this formula when creating a new measure with “integer” format

NonZero(
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
Not IsEmpty([Measures].[Issue resolution date])
AND
Datecompare(
'Jan 28 2021',
DatewithoutTime([Measures].[Issue resolution date])
)>0
AND
[Measures].[Issues resolved]>0
)
)
)

Martins / eazyBI support


hi @martins.vanags ,

Thank you for your reply.

I’m not trying to count, but instead filter by "issues with resolution date before mm dd yyyy.

This report gets the cycle time from now to 90 days ago. but without changing the measure, I cannot answer the question: what was my cycle time at 1st of feb 2021, for example.

measure

Can easily change it here. but I need to have this report user-ready: pick and select

Hi,

I see you found a way where to incorporate the date.
One more way you could consider would be using the “Time” dimension as page filter where you force which can serve as filtering rule (to start from…)
Then this time period can be addressed in your formula as [Time].CurrenthierarchyMember.Startdate
If any time period is selected report would use it as filter to count resolved issues before the start date of the member.

CASE WHEN
NOT [Time].CurrentHierarchyMember IS [Time].CurrentHierarchy.DefaultMember
THEN
NonZero(
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
Not IsEmpty([Measures].[Issue resolution date])
AND
Datecompare(
[Time].CurrenthierarchyMember.Startdate,
DatewithoutTime([Measures].[Issue resolution date])
)>0
AND
(
[Measures].[Issues resolved],
[Time].CurrentHierarchy.DefaultMember
)
>0
)
)
)
ELSE
NonZero(
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
Not IsEmpty([Measures].[Issue resolution date])
AND
(
[Measures].[Issues resolved],
[Time].CurrentHierarchy.DefaultMember
)
>0
)
)
)
END

Martins / eazyBI