Hi everybody!
I have a problem with one dashboard. In fact, i added some measure like this one below:
NonZero(
Count(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
DateInPeriod([Issue].CurrentHierarchyMember.get(‘Due date’),
[Time].CurrentHierarchyMember)
AND
[Measures].[Reste à faire late] = 1
)
)
)
Here, i was searching to know the numbers of task that remain to be done and that are overdue.
I think that there is no correlation between my measures and my filters. In fact, when i filtered by assignees or labels for example the histogram data bellow never change…
Can somebody help me?
Thank’s a lot
Muriella
Hi @Muriella ,
Can you please share what is the measure “Reste à faire late”? Is that some other calculation for the date? If you want to compare dates, maybe this demo report with “Issue due and overdue” could be useful for you as it contains several calculations with due dates:
https://eazybi.com/accounts/1000/cubes/Issues/reports/249876-issues-due-and-overdue
Also, don’t forget to use measure in your report (currently I notice that there is only property “Due date” and unknown measure “Reste à faire late”).
“The measure is a treasure” - it is for linking your data correctly to the Time dimension and could be the reason why your calculated measure is not working as expected.
If you want to link the measure to the Time dimension by “Due date”, you can add in your formula the filter expression “AND [Measures].[Issues with due date] >0”
best,
Gerda // support@eazyBI.com
Hi @gerda.grantina. Thank you for your answer. “reste à faire” means remains to be done and the measure is :
[Measures].[Issues with due date]-[Measures].[Issues with closure date]
@Muriella I think you can change your formula and check if the “Closure date” is empty.
NonZero(
sum(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
DateInPeriod(
[Issue].CurrentHierarchyMember.get("Due date"),
[Time].CurrentHierarchyMember
)
AND
IsEmpty([Issue].CurrentHierarchyMember.get('Closure date'))
),
[Measures].[Issues with due date]
)
)
Or if you would like to have a more advanced formula, you can see the measure “Issues due not in time” from the demo account and change the date “Resolved at” to “Closure date” so it suits your use case.
best,
Gerda