Hi there!
Is there a way to use Measures in both rows and columns at the same time?
I have a table with various members from an Area dimension as rows, and various calculated Measures as columns:
This works great.
I have also a Grouped calculated measure with a tuple returning all open issues belonging to Project A and all issues belonging to Area One regardless of the project:
([Measures].[Open issues],
[Project].[Project A])
+
([Measures].[Open issues],
[Area (Insight)].[Area One])
Is there any way I can use a measure which groups issues in the row of my table, and still keep the other calculated measures in the columns?
And if not, is there a way to group two dimensions so I can do a similar grouping, but in a Calculated member instead?
Thank you in advance!
Hi @Vlad_Neykov,
It wonât be possible to use âMeasuresâ both in Rows and Columns, as measures represent different metrics. Measure binds data together and allows you to represent data from different points of view (dimensions). And it wouldnât make any logic to show two measures from the Measure dimension on Rows and Columns, e.g., âIssues createdâ and âIssues resolvedâ. You can check eazyBI documentation to learn more about the Main concepts.
But as I understand, then you would like to have one dimension that would represent issues that are from âProject Aâ or have âArea (Insight)â with the value âArea Oneâ and use it in Rows and then select different metrics from Measure dimension?
In that case, I suggest checking JavaScript calculated custom fields where you can define this type of business logic. On this topic, I suggest checking my colleague Dainaâs presentation âMDX vs JavaScript: Behind Complex Filtersâ. And see related documentation about JavaScript calculated custom fields.
best,
Gerda // support@eazyBI.com
1 Like
Thanks Gerda!
Will check with our admins to see if we can use the JavaScript calculated fields.