Forum Discussion

npatten's avatar
npatten
Helper II
10 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 viszualization. The attached pictures shows two outcomes: on the left is the result of a DAX formula, the right is when i drag and drop column headings into the Table viz. Here's the DAX formula:

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

 

Thank you for any help

 

PBI Tables

Need Help
  • Vvelarde's avatar
    Vvelarde
    10 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]))

     

     

     

6 Replies

  • cosborn1231's avatar
    cosborn1231
    Resolver I
    10 years ago

    Hi npatten,

    I'm a little unclear here. I would suspect the summarize function would work for you in this instance.

    Is the data you are pulling in on the right hand side aggregated or is there anything different there?

     

    Thanks for double checking on that,

    Christian

     

    • npatten's avatar
      npatten
      Helper II
      10 years ago

      Hi--

       

      The table on the right hand side has the same columns as in the formula producing the table on the left. Basically, i just dropped the column headings into the table viz, and selected 'sum' on the ASAReceived. (ASA is appeal split amount, which is the equivalent of a monthly revenue/sales figure in the fundraising world). Aside from that, there isn't any aggregation going on behind the scenes. I've put the doc on OneDrive if you want to have a look: https://1drv.ms/u/s!AlU_gjUjfB2GgTfhNq3L2rhqEMVP

       

      Thank you!

      cosborn1231 wrote:

      Hi npatten,

      I'm a little unclear here. I would suspect the summarize function would work for you in this instance.

      Is the data you are pulling in on the right hand side aggregated or is there anything different there?

       

      Thanks for double checking on that,

      Christian

       

       

      • Vvelarde's avatar
        Vvelarde
        Community Champion
        10 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]))