Forum Discussion

jeremiels's avatar
jeremiels
Frequent Visitor
9 years ago
Solved

Dynamic Column calculation

Hello,   I want to add a column in my database who sums the total revenue for each line of business.   Region           Entity               Turnover A                    1                      ...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    jeremiels,

     

    Please use the DAX below to achieve your requirement.

    RegionTurnover = CALCULATE(SUM(Table1[Turnover]),ALLEXCEPT(Table1,Table1[Region]))

     

    ALLEXCEPT removes all context filters in the table except filters that have been applied to the specified columns.
    https://msdn.microsoft.com/en-us/library/ee634795.aspx

     

    Regards,

    Charlie Liao

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

jeremiels,

 

Please use the DAX below to achieve your requirement.

RegionTurnover = CALCULATE(SUM(Table1[Turnover]),ALLEXCEPT(Table1,Table1[Region]))

 

ALLEXCEPT removes all context filters in the table except filters that have been applied to the specified columns.
https://msdn.microsoft.com/en-us/library/ee634795.aspx

 

Regards,

Charlie Liao