Need help with a custom measure in Power Pivot

[mdsuther]

I'm would like to write a measure in Power Pivot to do the following:

I have a list of transactions by client with varying amounts of revenue for each transaction. I want my measure to SUM up the amount of revenue for each client, then filter those totals to only show clients who have totals of $25k or more in revenue.

Is this something I can do in a measure?

 

[RoryA]

Welcome to the forum.

It sounds to me like all you need is a measure summing the revenue. then in a pivot table simply apply a value filter to the client name field.

 

[mdsuther]

Welcome to the forum.

It sounds to me like all you need is a measure summing the revenue. then in a pivot table simply apply a value filter to the client name field.

This worked - thanks so much!!!!!

 

[RoryA]

Glad we could help.