Y axis aggregation

[Nyx]

When selecting a column to populate the Y axis of a scatter graph it automatically sums the whole column and puts a single value. However it lets me right click and select "Don't Summarize". This then plots all of the values from that column. Great. (Image below)

However if I use a measure, for example SUMX the column, the "Don't Summarize" option dissapears.

I need to use the measure as it has a calculation in it that cannot be replicated in a calculated column.

Is there a workaround to get the scatter graph to plot non-summarised data from a measure?

[henkvankester · Accepted solution]

I can't see your dataset, but maybe your problem is solved when you add another value to 'value'. 

It is like when you sell radios and tvs. On the X-axis the amount products sold is displayed and the Y-axis shows the profit. When you only put amount and profit to the scatterplot, you will see one dot and it's the total of all radios and tvs together. If you add product to value then you will see two dots.

Probably you should do something like this with your data. 

[Nyx]

Thank you, that seemed to have the same effect as the don't summarize.

I simply added the date column to the value field.

Still getting used to bi, came from using excel.

[amitchandak]

@Nyx , Measure is always aggregated, you can not use don't summarize