How to get sum over multiple rows in power bi?

[aschurf]

I'm trying to get the sum of certain lines (revenue) for each of the divisions. That is, I need to take the amount of the division's revenue and use it in another expression.

I tried to use this and it works fine if there is no split into different divisions (Dep1, Dep2, etc)

CALCULATE ( SUM([rev]), FILTER ( ALLSELECTED ('table'), 'table'[is_rev] = 1 )))

Perhaps there is another solution?

[amitchandak · Accepted solution]

@aschurf , Based on what I got, Try like

CALCULATE ( SUM([rev]), FILTER ( ALLSELECTED ('table'), 'table'[Dept] = max('table'[Dept] ) && 'table'[is_rev] = 1 ))

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.