Sum per Day

[Barre]

Hi,

I have this table visual with OrderDate and a Amount measure.

The OrderDate is of type Date, with Date Hierarchy off in the table.

What I´m struggeling to achieve is to visualize the total Amount per day, and not show all datapoints per each day. The OrderDate hierarchy needs to be off in the table.

Sample data

OrderDate    Amount

2019-01-01     100

2019-01-01     200

2019-01-01     300

2019-01-02     200

2019-01-02     300

How I want the table to show the values

OrderDate    Amount

2019-01-01     600

2019-01-02     500

[Tahreem24 · Accepted solution]

@Barre , Create a below measure :

Final Amount = CALCULATE([Amount Measure],ALLEXCEPT(MyTable,MyTable[OrderDate]))

[ryan_mayu]

@Barre 

pls try right click the date column name and select the column , not date hierarchy.

[Barre]

Thanks you for reply!

That is what I have done, and the data is shown as following.

OrderDate    Amount

2019-01-01     100

2019-01-01     200

2019-01-01     300

2019-01-02     200

2019-01-02     300

But I want the data to look like this 

OrderDate    Amount

2019-01-01     600

2019-01-02     500