X-Axis Category accumulated values

[woolf]

Hi,

I'm fighting with a problem to show the accumulated values in a line chart based on "Categories"

Line chart and accumulated values only works with Sorter and Measure based on Amount to get the "Total cars in stock" but I lose in the X-Axis the clear brand name. 

Helper =

VAR Value_1= SELECTEDVALUE(Tabelle[Sorter])

RETURN

CALCULATE (

    SUM(Tabelle[Amount]),

    FILTER ( ALL (Tabelle[Sorter]), Tabelle[Sorter]<=Value_1 ))

Amount	Brand	Sorter
333	Audi	1
123	Tesla	2
62	BMW	3
34	BYD	4
21	Lucid	5
17	Volkwagen	6
12	Mercedes	7
4	Renault	8
2	Nissan	9

Maybe someone has some solution.

./Florian

[SamWiseOwl · Accepted solution]

Hi @woolf 

Helper =

VAR Value_1= SELECTEDVALUE(Tabelle[Sorter])

RETURN

CALCULATE (

    SUM(Tabelle[Amount]),

    FILTER ( ALL (Tabelle[Sorter],Tabelle[Company]), Tabelle[Sorter]<=Value_1 ))

When sorting a column by another they become linked in the data. 

You need to remove the filter caused by both.