Forum Discussion
Cummulative vs individual in a line chart
- Anonymous2 years ago
Hi AmazingRandom ,
According to your describe, here are my test data:
1.Create a measure
Running total = VAR X = CALCULATE( SUM('Table'[value1]), FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date]))) VAR Y = CALCULATE( SUM('Table'[value2]), FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date]))) VAR Z = CALCULATE( SUM('Table'[value3]), FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date]))) RETURN X+Y+Z2.Create a line chart
3.Create a slicer and use data column as value
4.Final output
I hope this can help you. If you still can't do it, please provide your documents and hide your personal information.
In order for you to solve the problem faster, you can refer to the following documentation
How to Get Your Question Answered Quickly - Microsoft Fabric Community
Best Regards,
Albert He
Hi AmazingRandom ,
According to your describe, here are my test data:
1.Create a measure
Running total =
VAR X = CALCULATE(
SUM('Table'[value1]),
FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date])))
VAR Y = CALCULATE(
SUM('Table'[value2]),
FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date])))
VAR Z = CALCULATE(
SUM('Table'[value3]),
FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date])))
RETURN X+Y+Z
2.Create a line chart
3.Create a slicer and use data column as value
4.Final output
I hope this can help you. If you still can't do it, please provide your documents and hide your personal information.
In order for you to solve the problem faster, you can refer to the following documentation
How to Get Your Question Answered Quickly - Microsoft Fabric Community
Best Regards,
Albert He