Forum Discussion

npatten's avatar
npatten
Helper II
9 years ago
Solved

Calculated Table with the same values as a Table Viz

Hi--   I'm trying to teach myself how calculated tables function. I'm trying to create a Calculated Table that consolidates totals the same way that I'm currently getting using the Table viszualiza...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    hi npatten

     

    With your Summarize Column you are grouping the values of each 3 columns with unique values.

     

    You need to change your Summarize Columns to:

     

    Table = SUMMARIZECOLUMNS(Received[Appeal Division], Received[Appeal Revenue Program],"ASARECEIVED",Sum(Received[ASAReceived]))

     

     

     

npatten's avatar
npatten
Helper II
9 years ago

Thank you Vvelarde!

 

Would you will be willing to write a little bit about why it works? I'm unclear about how the the "ASRECEVED", SUM(Table[Column]) element works under the hood.

 

Thanks again!

 

Nathan

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

Summarize is make a "resume" of your table grouping by columns that indicate.

 

Example:

 

Table

 

ColA          Colb              ColC

USA           Miami            10

USA           Portland         15

Peru           Lima              8

Peru           Lima             8

Peru           Cuzco          10

Russia         Moscow        7

 

If you applied SummarizeColumns(Table[ColA], Table[ColB], Table[ColC]) you're telling to made a resume of this columns not sum or any other expression.

 

The result is: (All the unique combinations of this 3 columns)

 

ColA          Colb              ColC

USA          Miami              8

USA          Portland          15

Peru           Lima               8    (In original was 2 two identical rows)

Peru           Cuzco            10

Russia        Moscow          7

 

If you want to sum Column C yo need to tell to SummarizeColumn to do it this

 

SummarizeColumns(Table[ColA], Table[ColB], "NAME OF NEW COLUMN" SUM(Table[ColC]))

 

The result is: (All the unique combinations of first 2 columns and Sum of Col 3)

 

ColA          Colb              NAME OF NEW COLUMN

USA          Miami              8

USA          Portland          15

Peru           Lima              16  (sum 8 + 8)

Peru           Cuzco            10

Russia        Moscow          7

 

I hope this help you

 

  • npatten's avatar
    npatten
    Helper II
    9 years ago

    This explanation is great, thank you!!!