Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Aggregate calculated column by category

Hi all

 

New to DAX/Power BI, and I have the following issue. I have the data from column A-D, and I want to calculate column E. Can anyone point me in the right direction?

 

 

 

 

 

 

 

 

 

Thanks. 

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous 

     

    Hi

     

    =
CALCULATE (
    SUM ( TableName[SalesAmount] ),
    ALLEXCEPT ( TableName, TableName[Sales-Country], TableName[Year-Week] )
)

2 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    7 years ago

    Anonymous 

     

    Hi

     

    =
CALCULATE (
    SUM ( TableName[SalesAmount] ),
    ALLEXCEPT ( TableName, TableName[Sales-Country], TableName[Year-Week] )
)