topic Re: Summarize function providing wrong results. in DAX Commands and Tips

Summarize function providing wrong results.

PradneshSP — Fri, 23 Sep 2022 14:50:57 GMT

I'm trying to summarize a table to display values by month

SUMMARIZE(Sales_View,Sales_View[Div],Sales_View[Code],Sales_View[Brands],Sales_View[Billing Month_Year],Sales_View[Type],"Value",SUM(Sales_View[VALUE]))

The SUM is calculated wrong. It's displaying more than expected value.

Re: Summarize function providing wrong results.

johnt75 — Mon, 26 Sep 2022 08:47:40 GMT

Don't use SUMMARIZE to add calculated columns, use ADDCOLUMNS instead

ADDCOLUMNS ( SUMMARIZE ( Sales_View, Sales_View[Div], Sales_View[Code], Sales_View[Brands], Sales_View[Billing Month_Year], Sales_View[Type] ), "Value", CALCULATE( SUM ( Sales_View[VALUE] ) ) )

If you're interested, there's a SQL BI article about it.

Re: Summarize function providing wrong results.

PradneshSP — Fri, 23 Sep 2022 20:14:11 GMT

It still provides wrong results

Re: Summarize function providing wrong results.

johnt75 — Mon, 26 Sep 2022 08:48:04 GMT

My mistake. I have edited my original post to include the required CALCULATE around the SUM.