How to Count Conditional Visual Column based on DAX

Hi Polly,

I have done this on excel by using pivot table and some formulas. Now i am transferring this template on Power Bi.

Following is Excel Results.

Following is the sample data.

4.Cummulative total = if(

    NOT(ISBLANK([SUM Of Total OrdersAll])),

    CALCULATE(

        [SUM Of Total OrdersAll],

        FILTER(

            ALL(examp[SKU]),

            SUM(examp[Total Orders])<=[SUM Of Total OrdersAll]

        )

    )

)

1.SUM Of Total OrdersAll = sum(examp[Total Orders])

2.sum of total orders by SKU = CALCULATE([SUM Of Total OrdersAll],REMOVEFILTERS(examp[SKU]))

3.% of Orders by Month = DIVIDE([SUM Of Total OrdersAll],[sum of total orders by SKU])

5.% of Cummulative Total = DIVIDE([Cummulative total],[sum of total orders by SKU])

SKUMonth-YYYYTotal Orders