I want to filter on issues with selected Labels in my defined measure

Questions & Answers
,
1

Hello,

I need help for my defined measure “sum of progress %” it’s a measure to calculate progress by using issue due and a free_field_choice_01 by filtering by component, département and Label :
CoalesceEmpty(
Cache(
Sum(
Filter(
Descendants([Issue].Currentmember, [Issue].[Issue]),
NOT IsEmpty([Measures].[Issue due date])
AND
(
IsEmpty([Measures].[Issue closed date])
OR
DateBeforePeriodEnd([Measures].[Issue closed date],[Time].CurrentHierarchyMember)
)
AND
(
IIf([Component].CurrentHierarchyMember.Level.Name=‘Component’,
[Measures].[Issue components]=[Component].CurrentHierarchyMember.Name,
CBool(1))
)
AND
(
IIf([Département].CurrentHierarchyMember.Level.Name=‘Département’,
[Measures].[Issue Département IRS]=[Département IRS].CurrentHierarchyMember.Name,
CBool(1))
)
),
IIf(NOT IsEmpty([Measures].[Issue closed date]),
1,
CASE
WHEN ([Measures].[Issues history],[free_field_choice_01].[100]) > 0 THEN 1
WHEN ([Measures].[Issues history],[free_field_choice_01].[80]) > 0 THEN 0.8
WHEN ([Measures].[Issues history],[free_field_choice_01].[60]) > 0 THEN 0.6
WHEN ([Measures].[Issues history],[free_field_choice_01].[40]) > 0 THEN 0.4
WHEN ([Measures].[Issues history],[free_field_choice_01].[20]) > 0 THEN 0.2
WHEN ([Measures].[Issues history],[free_field_choice_01].[0]) > 0 THEN 0.0000001
WHEN ([Measures].[Issues history],[free_field_choice_01].[(none)]) > 0 THEN 0.0000001
END
)
))
,0)

The problem is when I filter on a specific Labels, it’s doesn’t work the measure calculate all the issues.

How can I filter on issues with a specific Label ? (I have 2 labels : 2024 and 2023)

Thank you for your help

2

Hello, could someone help me please ?

3

Hi @Megacreation
I checked the created measure in my test environment and couldn’t reproduce the problem. I added the “Label” dimension in Pages, and I was able to filter the issues successfully.
Can you please demonstrate how you filter your issues and why the returned result is not what you expect?

best,
Gerda

4

Hello,

When I click on the “Drill Through issue” on Sum of progress %, I see results associated with both labels “2023” and “2024,” even though I’ve specifically filtered the report to display only issues with label for “2024.”

The progress based on % in superior to 100% which is impossible here is the formula :

CASE WHEN (
[Time].DefaultMember,
[Measures].[Issues with due date]
) > 0
THEN
[Measures].[Sum of progress%]
/
(
[Time].DefaultMember,
[Measures].[Issues with due date]
)
END

image
image432×611 10.3 KB