I have 4 Columns, First is Date type which will be Axis Value (X- Axis), 3 Decimal Type Value (Values Field) which will represent as Line Chart i.e. 3 Lines inside the chart.
Problem?
When I drag and drop the Decimal Type Value inside the Values Field in Line Chart, it takes as SUM.I already selected Don't Summarize in Column tools tab with Uncategorised as Data Category.The problem is when I click the down arrow in the Values Field, it doesn't shows "Don't Summarize" Option.Now I need my data as it is, no sum no count, nothing.
How Can I achieve that?
Best Answer
There is chance to duplicating the values so you might get more value than the present value. So have to create new table using below DAX then apply to you visual.
DISTINCT(SUMMARIZE(ResellerSales_USD , DateTime[CalendarYear] , "Sales Amount (USD)", SUM(ResellerSales_USD[SalesAmount_USD]) )