You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I am new to EazyBI and MDX syntax. I have an issue type 'Task' with a field 'Task Type' which specifies the type of the task (Eg: Architecture / Technical / Project Management etc).
I would like to create a Calculated member in Issue type so that I can segregate this Issue Type field by different Task types and use that calculated member for various measure.
Please can you help with the MDX for the above calculated measures.
You could use the tuples from eazybi: https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures#Calculatedmeasures-Tuples
In your case something like:
@Fabian Lim is correct; tuples are the way to go!
Only, in addition, I would suggest you also add a measure you wish to see the totals for (eazyBI saying goes "Measure is a treasure!" ;)). So the complete new calculated member would be:
Or you can select the measures and use the Issue Type and Task Type dimensions as page filters.
Lauma / email@example.com