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?             ...
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] )
)
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] )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Zubair_Muhammad  That works, thanks!