Hello,
I have set up a data import where new data is imported as a measure for the Assignee/Time dimensions. However when I embed that measure on a report: Assignee as rows dimension, Issues Created and new measure as columns.
When I add TIme as a Paged dimension - there is no issue (i assume cause both - Time and Assignee dimensions was present in the data import) but as soon as I add Issue Type as another Paged dimension and start selecting anything but ‘All’ - I am getting no data in my imported measure. Is there any way to overcome that ?
I only need to filter Assignees by that page value leaving the imported measure values intact.
Hi @Alexey_Sviridov,
You are right - the Issue type dimension is not mapped for the measure.
Therefore, the measure only returns the value for “All Issue types”.
Once you select a specific member from the “Issue type” or any other unmapped dimension - the app slices data by that dimension, and nothing remains to show.
You might overcome this behavior by defaulting the specific dimension for the measure. You might achieve that by calling for the .DefaultMember
You might read more about the .DefaultMember here - DefaultMember.
The expression for the measure might be as follows.
([Issue Type].DefaultMember,
[Measures].[<your measure>])
However, suppose you might have multiple additional unmapped dimensions, and you only care about the Time and Assignee. In that case, you might use the DefaultContext instead to only keep the context of selected dimensions.
You might read more about the DefaultContext here - DefaultContext.
The expression to only consider dimensions “Time” and “Assignee” might be as follows.
DefaultContext(
([Time].CurrentHierarchyMember,
[Assignee].CurrentHierarchyMember,
[Measures].[<your measure>])
)
Regards,
Oskars / support@eazyBI.com