Hi,
I am very new to EazyBI, and I am having some challenges as stated below;
The measure below counts issues with a “Project Specialist Value”
Aggregate({
Except(
[Project Specialist].[Project Specialist].Members,
{
[Project Specialist].[(none)]
})
},
[Measures].[Issues created]
)
But I want to be able to see a rolling count/amount from month to month, week to week.
This other one counts issues with “No Project Specialist Value”
(
[Project Specialist].[(none)],
[Measures].[Issues created]
)
I also want to be able to see a rolling count/amount from month to month, week to week.
An finally,
I have this one that calculates sum total for “one-Time fee”
NonZero(
Sum(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
[Measures].[Issues created]>0
),
[Measures].[Issue One-Time Fee]
)
)
I want to be able to see the sum amount of “one-Time fee” , when the is a “Project Specialist Value” and also when there is “No Project Specialist Value”. I would appreciate it if this amount can also be a rolling sum from month to month, week to week.
Regards,