Hi, I try to use a user define member, but it returns nothing, could someone please tell me what I've done wrong?
Thanks
(the ProblemFoundInRelease is imported as diememsion)
Hi @Min Tang ,
From the screenshot, I can't determine if the ProblemFoundInRelease dimension is selected in the report or not. However, with the suggestion below, I assume it is not.
Your calculated measure is empty because the ProblemFoundInRelease dimension is not present in the report, or a member is selected, not matching the specified name.
I suppose you intend to retrieve the cumulative number of issues created weekly, matching the value "MOF.4..." in the specific field. In that case, I recommend defining a calculated member in the ProblemFoundInRelease dimension, aggregating all the members matching the naming convention. The formula could look similar to the one below:
Aggregate(
Filter(
[ProblemFoundInRelease].[ProblemFoundInRelease].Members,
[ProblemFoundInRelease].CurrentMember.Name MATCHES ".*MOF\.4.*"
)
)
See more details on creating calculated members in dimensions and how they differ from calculated measures here - https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members#Calculatedmeasuresandmembers-Howtodefineanewcalculatedmember.
Next, remove the CASE WHEN conditions from the calculated measure "MOF4Pr" and create a tuple of the measure "Issues created" and the ProblemFoundInRelease dimension calculated member defined in the first step.
Best,
Roberts // support@eazybi.com
Hi @Min Tang
You can use a combination of SUM and filters with a match statement as described in this post to get the isues created by week: https://community.eazybi.com/t/filter-issues-using-summary-which-contains-a-specific-word/7987
You can then use the same formula that you use for the cumulative count.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.