Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
gumis_rulez
Helper I
Helper I

Graph takes data from sales instead of rolling column

I am creating a  New Customers Sales Rolling measure by creating a summarize table in dax:

 

New Customers Sales Rolling =
VAR CustomerOrders = ADDCOLUMNS(
        SUMMARIZE(
            Orders,
            Orders[Klient_Nazwa],
            Orders[Data Zamówienia],
            "Year", YEAR(Orders[Data Zamówienia]),
            "TotalSales", SUM(Orders[Sprzedaż])
        ),
        "TotalOrdersByClient", CALCULATE(
            SUMX(
                SUMMARIZE(
                    Orders,
                    Orders[Klient_Nazwa],
                    "TotalOrders", DISTINCTCOUNT(Orders[ ID Zamówienia])
                ),
                [TotalOrders]
            ),
            ALLEXCEPT(
                Orders,
                Orders[Klient_Nazwa]
            )
        )
    )

Var CustomerOrdersFiltered = FILTER(CustomerOrders, [TotalOrdersByClient] <= 2)

Var CustomerOrdersFilteredGrouped = GROUPBY(CustomerOrdersFiltered, [Year], "SalesbyYear", SUMX(CURRENTGROUP(), [TotalSales]))

Var CustomerOrdersFinal =
    ADDCOLUMNS(
        CustomerOrdersFilteredGrouped,
        "Rolling", SUMX(
            FILTER(
                CustomerOrdersFilteredGrouped,
                [Year] <= EARLIER([Year])
            ),
            [SalesbyYear]
        )
    )

Return SUMX(CustomerOrdersFinal, [Rolling])


The CustomerOrdersFinal table from the above measure looks like this:

 

012.JPG

 

In the last line of the dax measure I am referring to rolling column, but when I am doing a simple graph, it seems data from SalesByYear are taken into consideration:

 

011.JPG

 

What am I doing wrong?

 

File to download: https://drive.google.com/file/d/12sVJPAB-3xC1B8EWRoX5-uDKRFP3VxMo/view?usp=sharing 

1 REPLY 1
lbendlin
Super User
Super User

you may be overcomplicating things a little.  Try this

 

 

New Customers Sales running total = 
var o = FILTER(ALLSELECTED(Orders[Klient_Nazwa]),calculate(DISTINCTCOUNT(Orders[ ID Zamówienia]))<3)
var y = max('Calendar'[Year])
return CALCULATE(sum(Orders[Sprzedaż]),'Calendar'[Year]<=y,Orders[Klient_Nazwa] in o)

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.