Forum Discussion

tnwcloud's avatar
tnwcloud
Regular Visitor
3 years ago
Solved

Substitute value when filtered

I have a dataset where some Items are members of a Group. For Groups, one Item is designated Type of Parent and the others, if any, are designated Type of Child. Each Item not in a Group carries an A...
  • bot_damo's avatar
    bot_damo
    3 years ago

    Hi tnwcloud,

    I think the following DAX will work here.

    CALCULATE(SUM('Table'[Amount]), ALLEXCEPT('Table', 'Table'[Group]))

    Kind Regards



bot_damo's avatar
bot_damo
Frequent Visitor
3 years ago

Hi tnwcloud,

I think the following DAX will work here.

CALCULATE(SUM('Table'[Amount]), ALLEXCEPT('Table', 'Table'[Group]))

Kind Regards