topic Re: Summarize no working, what is the problem? in DAX Commands and Tips

Summarize no working, what is the problem?

karlo — Thu, 28 Nov 2019 23:54:02 GMT

Hi!,

I'm trying to get a cumulative value but I can't, the DAX code is:

--------------------------

TABLE_A =
VAR TABLE_X = UNION(CALCULATETABLE(SUMMARIZE(TABLE_1; TABLE_1[ID]; TABLE_1[m00]); TABLE_1[m00]= 1);
CALCULATETABLE(SUMMARIZE(TABLE_1; TABLE_1[ID]; TABLE_1[m01]); TABLE_1[m01]= 1);
CALCULATETABLE(SUMMARIZE(TABLE_1; TABLE_1[ID]; TABLE_1[m02]); TABLE_1[m02]= 1))
RETURN(SUMMARIZE(TABLE_X ;[ID];"TOT";SUM([m00])))

Problem: RETURN(SUMMARIZE(TABLE_X ;[ID];"TOT";SUM([m00]))).... Cannot identify the table that contains the column [m00]

--------------------------

TABLE_X is:

ID	m00
1	1
1	1
1	1
2	1
2	1
3	1

I need to the result:

ID	m00
1	3
2	2
3	1

I appreciate very much the comments

Thanks,

Re: Summarize no working, what is the problem?

Nathaniel_C — Fri, 29 Nov 2019 01:18:04 GMT

Hi karlo ,
Try this:

Z = CALCULATE(SUM(x[m00]),ALLEXCEPT(x,x[ID]))

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

Re: Summarize no working, what is the problem?

karlo — Sat, 30 Nov 2019 03:28:34 GMT

Thank you Nathaniel_C

Re: Summarize no working, what is the problem?

Nathaniel_C — Sat, 30 Nov 2019 13:26:10 GMT

You are welcome!
Nathaniel