• Hi,

    It's a little hard to tell without knowing your data structure but it seems as if your measure called "LatencyDays" needs to be split via a dimension.

    It looks as if what your cube is reporting is correct in that it's summing up ALL of your latency days (15+23=38) without the context of a dimensional member to slice it by.

    So, say you had a dimension that was joined to whatever measure group your LatencyDays measure is in, let's call it LatencyType and assume it has one attribute called LatencyType. Then your calculated measure would look like this:

    MEMBER [Measures].[SalesLatency]

    AS

    SUM([LatencyType].[LatencyType].&[Sales], [Measures].[LatencyDays])

    Hope this helps 🙂


    I'm on LinkedIn