Forum Discussion

Barre's avatar
Barre
Icon for Helper I rankHelper I
5 years ago
Solved

Sum per Day

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 ...
Need Help
  • Tahreem24's avatar
    Tahreem24
    5 years ago

    Barre , Create a below measure :

    Final Amount = CALCULATE([Amount Measure],ALLEXCEPT(MyTable,MyTable[OrderDate]))
     
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
5 years ago

Barre , Create a below measure :

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