Build a KPI (or measure) based on "Bubble up exceptions"


  • In a cube with MDX I built a measure (or KPI, it’s the same idea) that bubbles up exceptions, like loss.

    I used ths mdx syntax to build the measure: min( descendants([Customers].currentmember) ,[Measures].[G Profit]), in order to get at a higher level the minimum of the lower level (and in that way without having to drill down getting on top levels KPI's regarding single products or customers at low levels).

    How can I get it in DAX?

    Sunday, July 01, 2012 3:31 PM


All replies