Some crazy MDX Demonstration to my fellow friend @maialson

WITH MEMBER [Measures].[one] as 1 MEMBER [Measures].[condic] as iif( inStr([Customers].currentMember.name,"a")>0, 0,[Measures].[one]) MEMBER [Measures].[Sequential] as rank( [Customers].currentMember, extract( nonEmptyCrossjoin( nonEmptyCrossjoin( [Territory].currentMember, [Customers].[Customer].members ), [Product].currentMember ), [Customers] )

    )
    
MEMBER [Measures].[Total] as 
    count(
            nonEmptyCrossjoin(
                nonEmptyCrossjoin(
                    [Territory].currentMember,
                    [Customers].[Customer].members
                ),
                [Product].currentMember
            )
    )
    
MEMBER [Measures].[MeasureIf] as 
    iif([Measures].[condic]=0,[Measures].[Sequential],0)
    
MEMBER [Measures].[AcumIf] as 
    sum(
        
            extract(nonEmptyCrossjoin(
                nonEmptyCrossjoin(
                    [Territory].currentMember,
                    [Customers].[Customer].members
                ),
                [Product].currentMember
            ),[Customers]).item(0) : 
            extract(nonEmptyCrossjoin(
                nonEmptyCrossjoin(
                    [Territory].currentMember,
                    [Customers].[Customer].members
                ),
                [Product].currentMember
            ),[Customers]).item([Measures].[Sequential]-1)
        

          ,
        [Measures].[MeasureIf]
    )

            
MEMBER [Measures].[Last AcumIf] as 
    max(
            nonEmptyCrossjoin(
                nonEmptyCrossjoin(
                    [Territory].currentMember,
                    [Customers].[Customer].members
                ),
                [Product].currentMember
            ),
            [Measures].[AcumIf]
    )

SELECT nonEmptyCrossjoin( nonEmptyCrossjoin( [Markets].Children, [Product].Children ), [Customers].children ) ON ROWS,

{
    [Measures].[Quantity],
    [Measures].[Sequential],
    [Measures].[condic],
    [Measures].[Total],
    [Measures].[MeasureIf],
    [Measures].[AcumIf],
    [Measures].[Last AcumIf]
}
ON COLUMNS

from [SteelWheelsSales]

marpontes/conditional-running-totals.mdx