MDX Scripting help

Questions & Answers
, ,
1

I want a calculated measure which increase by 2 upon each increase of issue count.

Example:

We have,
1 issue - Then Value will be 0
2nd issue - The value will be 2
3rd issue - The value will be 4
After 4th issue the value should be 4 only, the value will not increase after 4
for each issue now the value will be 4.

2

Hi,

You could use the Rank function to return the rank number for issue from a sorted list and then multiply the value by 2.
https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference

If the calculated results exceeds 4, return 4.

Martins / eazyBI