Don't Summarize Option Problem In Power BI

user_8653140 0
Viewed 7561

What I Have?
So, 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?

powerbi data-visualization data-modeling
1 Answers

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])
)

user_200586040
Related