Forum Discussion

powerbinoobster's avatar
powerbinoobster
Helper I
3 years ago
Solved

Help creating a line value for Clustered Column Chart?

So I have this Clustered Column Chart.

I want to create a meansure/line value that starts at 949 and continues adding the "Originated" value for each month so like this.

So 949 + 49 = 998 for Jan, 998 + 73 = 1071, etc.. How would I create this measure?

Need Help
Show and Tell
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi powerbinoobster ,

    According to your description, here's my solution.

    Sample:

    Create a measure.

    Originatd measure =
SUMX (
    FILTER (
        ALL ( 'Table' ),
        'Table'[Month Number] <= MAX ( 'Table'[Month Number] )
    ),
    'Table'[Originated]
) + 949

    Get the result.

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    3 years ago

    Hi powerbinoobster ,

    According to your description, here's my solution.

    Sample:

    Create a measure.

    Originatd measure =
SUMX (
    FILTER (
        ALL ( 'Table' ),
        'Table'[Month Number] <= MAX ( 'Table'[Month Number] )
    ),
    'Table'[Originated]
) + 949

    Get the result.

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.