MDX Expression to Filter Calculated Measure for members that have ROE > 12%

Question

I have a calculated measure called Return on Equity and another called Net Income and a dimension called customers. I would like to see the combined Return on Equity for all customers that have a net income greater than $1,000. How do I create an MDX expression do show that?

mxix mxix · Accepted Answer · 2016-07-15T18:26:34

The title and the explanation don't really match... over 1000 and over 12% ROE not exactly the same, i'll try to answer the explanation.

You did not provide any Cube structure so i'll give you a generic example:

WITH
SET CustomerOver1000
AS
FILTER (
    [Customer].[Customer].MEMBERS,
    [Measures].[Net Income] > 1000
)
MEMBER ROECostumerOver1000
AS
SUM(CustomerOver1000,[Measures].[ROE])
select
    {ROECostumerOver1000} on 0
from [myCube]

MDX Expression to Filter Calculated Measure for members that have ROE > 12%

2 Answers