Forum Discussion

adityah's avatar
adityah
Frequent Visitor
3 years ago
Solved

How to summarize a table correctly

Hi,   Please excuse if the question seems trivial, I am a newbie and have tried various solutions which havent worked. I am trying to summarize a table 'Budget' which looks like this:   Region...
  • amitchandak's avatar
    amitchandak
    3 years ago

    adityah , a sum(Table[USD]) should work in table visual with all other columns

     

     

    If you need a data table,

     

    Summarize(Table, Table[Region], Table[Power BI], Table[Cat], "Actual", SUm(table[USD]))

     

    Learn Power BI: Calculatetable, Summarize, Groupby, SummarizeColumns, Except, Distinct, Generateseries, Generate, Crossjoin
    https://youtu.be/cN8AO3_vmlY?t=22350

  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi adityah 

    try to add a calculated table like:

    Table = 
ADDCOLUMNS(
    SUMMARIZE(
        budget,
        budget[Region],
        budget[Power BI],
        budget[Cat.]
    ),
    "Actual",
    CALCULATE(SUM(budget[USD]))
)

    it worked like:

FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi adityah 

try to add a calculated table like:

Table = 
ADDCOLUMNS(
    SUMMARIZE(
        budget,
        budget[Region],
        budget[Power BI],
        budget[Cat.]
    ),
    "Actual",
    CALCULATE(SUM(budget[USD]))
)

it worked like: