Customers with Sales Greater than $100k per Year

[jaydee]

Hi,

I'm trying to write a measure that gives me a list of customers that purchased more than $100k each year, for the past 5 years, that I can put into a matrix visual.

The problem is if I write:

FILTER(

VALUES('Customer Lookup'[Customer Name]),

[Total Sales] > 100000

)

It's evaluated at the grand total level, verses the customer meeting the criteria every since year since for example 2016. Does anyone have any ideas?

Thank you,

[jaydee]

Thanks appreciate your help! Hope you have a great evening.

[amitchandak · Accepted solution]

@jaydee , plot this measure with customer name in visual

countx(values('Customer Lookup'[Customer Name])
FILTER(
'Customer Lookup', [Total Sales] > 100000
))