Accumulative function not working :(

MarkoTheWhite — Fri, 10 Nov 2017 11:09:02 GMT

Dear ALL,

I am completly new to power BI, so please be patent with me.

I now that this topick was opened before and i had tried to use suggestions from previous posts, but with no success.

Here is my example:

I want to represent "line and stacked column chart" where columns would represent number of lines per LDM (loading meters) class and line should be cumulative value of LDM's from shipment class 1 to 10.

Meaning:

Class1 = sum of LDM in that class

Class2 = LDM from class 1 + LDM from class 2

etc..

this is data set:

and this is formula i am using:

accumulative LDM Column = CALCULATE(sum('Try me'[Shipment Loading Meters (LM)]); filter(ALL('Try me'[Ship Class]); 'Try me'[Ship Class]<=max('Try me'[Ship Class])))

But, as you can see, i am doing something wrong here, since it is always displaying this chart:

Any suggestions? Please explain me, what am i doing wrong here, since i dont understand these expressions at all.

Many thanks.

Re: Accumulative function not working :(

Eric_Zhang — Mon, 13 Nov 2017 06:36:49 GMT

MarkoTheWhite

In you case, you may need a measure as below. See more in the attached pbix file.

accumulative LDM =
SUMX (
    FILTER (
        ALLSELECTED ( yourTable ),
        yourTable[ship class] <= MAX ( yourTable[ship class] )
    ),
    yourTable[Shipment Loading Meters]
)

topic Re: Accumulative function not working :( in Developer

Accumulative function not working :(

Re: Accumulative function not working :(