Reference line on a combo chart showing total irrispective of month

[Matt22365]

Hi

I hope someone can help

I am trying to write a measure which sums the total costs in a column and plot it as a horizontal target line on the graph. The bit I cannot get to work is making it consistant across all months (the X axis) rather than variable depending on the month.

I have had a look at using the constant line feature, however I need it to by dynamic and change as more costs are added to the source data

Your help would be greatly appreciated

Matt 

[Icey · Accepted solution]

Hi @Matt22365 ,

Try this:

1. Create a Measure like so:

Sum Measure = SUMX ( ALLSELECTED ( 'Table' ), 'Table'[Value] )

2. Create a Line and Stacked column chart. And I opened "Align zeros".

Then, the Sum Measure will change as the underlying data changes.

Best Regards,

Icey

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

[Matt22365]

Hi

Thank you, that worked great

Matt 

[Greg_Deckler]

Use ALL or ALLEXCEPT or REMOVEFILTERS to exclude your month/date as a filter.