Answer the question
In order to leave comments, you need to log in
How to write percentage metric in mdx?
There is such a simple cube:
Dim1: Browser with elements: FF, Chrome, IE, bot
Dim2: Calendar with daily dynamics
Metric - Number of
records the following expression is obtained:
member bla as 100 * aggregate(except([Browser].members, [Browser].[bot]), [Measures].[Number of records])/ [Measures].[Number of records]
select [Calendar] on columns,
[Browser] on rows
where bla
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question