Forum Discussion

Bansi008's avatar
Bansi008
Helper III
2 years ago
Solved

Required help in conditional SUM function using DAX query.

Hi there, I have given sample table for reference, using SEC_ISSUER as identifier I need to calculate sum of total value using VALUE column for example, DAX query should sum up for all sec_name val...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi Bansi008 
    You can use the measure :

    sum_by_issuer = CALCULATE(
        sum('Table'[VALUE]),ALLEXCEPT('Table','Table'[SEC_ISSUER]))

    The pbix is attached

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

Hi Bansi008 
You can use the measure :

sum_by_issuer = CALCULATE(
    sum('Table'[VALUE]),ALLEXCEPT('Table','Table'[SEC_ISSUER]))

The pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.