summarizing column value

[harshoyal67]

i want to summazige my coloum value and summarize it in to one value set, so as to get one spent and click value for one advertisement.

example

Advertisement                         datetime                             hourly_spent

1 fb-2342234-111                  6/12/2017 10:2:42 pm         250

2 fb-2342234-111                  6/12/2017 11:2:42 pm        420

3 fb-2344334-211                  6/12/2017 10:2:42 pm        784

4 fb-2347556-311                  6/12/2017 10:2:42 pm        985

so i want to get one cumulative value for 1 and 2 data set. that is

Advertisement                  datetime           hourly_spent

fb-2342234-111                                           670

help me with this solution

[v-qiuyu-msft · Accepted solution]

Hi @harshoyal67,

You can create a measure:

Cumulative = CALCULATE(SUM('Table1'[hourly_spent]),FILTER(ALLSELECTED('Table1'),VALUE(LEFT('Table1'[Advertisement]))=1 || VALUE(LEFT('Table1'[Advertisement]))=2))

Best Regards,
Qiuyun Yu