Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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:
Solved! Go to Solution.
@jaydee , plot this measure with customer name in visual
countx(values('Customer Lookup'[Customer Name])
FILTER(
'Customer Lookup', [Total Sales] > 100000
))
Thanks appreciate your help! Hope you have a great evening.
@jaydee , plot this measure with customer name in visual
countx(values('Customer Lookup'[Customer Name])
FILTER(
'Customer Lookup', [Total Sales] > 100000
))
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.