Summarize no working, what is the problem?

[karlo]

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,

[Nathaniel_C · Accepted solution]

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

[karlo]

Thank you Nathaniel_C

[Nathaniel_C]

You are welcome!
Nathaniel