Get sum of values from two entries in a column and apply that sum to another table column entry

[Asha_2021]

Details:

Hi 

I need value for for Bulk Geocoder row  : 

this value  needs to calculated by summing up two entries coming from CPM View Extract(2) table , look for last column values, if we sum these two values, then that will be the value for AWS sum table Bulk Geocoder entry

How to sum these two entry value  from  CPM View Extract(2) table  and assign it to the single entry Bulk Geocoder in AWS Sum table.

Pls help

@heaher_iTalent  @Greg_Deckler 

[v-kelly-msft · Accepted solution]

Hi  @Asha_2021 ,

Based on my understanding,you could create a calculated column similarly as below:

Column =
SWITCH (
    'Table'[Application name ],
    "bulk geocoder",
        SUMX (
            FILTER ( 'Table (2)', 'Table (2)'[Ord Application name ] = "e" ),
            'Table (2)'[value1]
        )
            + SUMX (
                FILTER ( 'Table (2)', 'Table (2)'[Ord Application name ] = "f" ),
                'Table (2)'[value1]
            )
)

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[Greg_Deckler]

@Asha_2021 You mentione "last column values". What indicates that the column values are "last"?