Forum Discussion

Josearce's avatar
Josearce
Regular Visitor
7 years ago
Solved

Table

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 r...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    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

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

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