Table

[Josearce]

I have a table with columnns A through D. I need to find a way to sum the data from column D filtered by column C. Finally, if I take the column C out of the table, D still need to present the total results as filtered by column C.

I will try to make an example:

Column A. Column B. Column C. Column D
Event 1. Event 1. Tax Id 1. 4
Event 2. Event 2. Tax Id 2. 4
Event 3. Event 3. Tax Id 3. 5

Result I need

Column A. Column B. Column D
Event 1. Event 1. 4
Event 2. Event 2. 4
Event 3. Event 3. 5

[v-frfei-msft · Accepted solution]

Hi @Josearce,

We can create a calculated table as below.

Table = SUMMARIZE(Table1,Table1[Column A],Table1[Column B],"D",CALCULATE(SUM(Table1[Column D]),VALUES(Table1[Column C])))

Regards,

Frank