Measure to show sum as constant line for every month

[Anonymous]

Hello,

I want a graph to show a line that shows the sum of all months as a constant line, so not the value of the month on the x-axis, but the sum:

The current measure for the orange line is: 

CALCULATE (SUM([Amount]); ALL('Calendar'[month]))

but the value calculated with 'sum([Amount]) should be presented as a constant horizontal line.

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

Make sure there existing a relationship between Calendar table and data table which contains amount values. Please drag [month] field from 'Calendar' table onto X-axis of chart.

Best regards,

Yuliana Gu