Forum Discussion

stepantuzil's avatar
stepantuzil
Regular Visitor
2 years ago
Solved

Cumulative Sum with changing division

Hello,  I'm trying to divide cummulativ sum with value from another column. I got rigth the cummulativ sum, but if I try to divide it, it divide the whole sum.. Data: Calendar Date  SUM_RT ...
Need Help
  • stepantuzil's avatar
    stepantuzil
    2 years ago

    Hello, 
    I solved the problem. I used this measure:

    _Divide SUM = SUMX(Values('LISA PBI Development of Sales'[Calendar day.Calendar day Level 01]), Divide([Sum_sales],[MAX_correction]))

    Inside the cummulative measure:

    SUM_RT_w_correction = 
CALCULATE(
    [_Divide SUM], 
    FILTER(
        ALL('LISA PBI Development of Sales'[Calendar day.Calendar day Level 01]),
        'LISA PBI Development of Sales'[Calendar day.Calendar day Level 01] <= MAX('LISA PBI Development of Sales'[Calendar day.Calendar day Level 01]) && 
        'LISA PBI Development of Sales'[Calendar day.Calendar day Level 01] >= MAX('PPC Project Materials'[Start of contract])
    )
)

    Result in graph: 



    Have a nice day.

lbendlin's avatar
lbendlin
Super User
2 years ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523