Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Group By Filter for Total Amounts

So I have a dataset that is full of positive and negative numbers ex: Bill Number Charge 1 -10 1 20 2 8 2 -9 2 -3   I want to create a few measures that sum up the count...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 

     

    The following measures are for your reference.

    Sum of Bills = CALCULATE(SUM('Table'[Charge]), ALLEXCEPT('Table', 'Table'[Bill Number]))

     

    Grouped = COUNTX(SUMMARIZE(FILTER('Table', [Sum of Bills] > 0), 'Table'[Bill Number]), [Bill Number])

     

    Output:

     

    Best Regards,
    Yulia Xu

     

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous 

 

The following measures are for your reference.

Sum of Bills = CALCULATE(SUM('Table'[Charge]), ALLEXCEPT('Table', 'Table'[Bill Number]))

 

Grouped = COUNTX(SUMMARIZE(FILTER('Table', [Sum of Bills] > 0), 'Table'[Bill Number]), [Bill Number])

 

Output:

 

Best Regards,
Yulia Xu

 

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