How to show just the customers with sales en both years

[Anonymous]

Hey there;

I want to show just the customers who have sales records in both years. Example bellow:

[v-xicai · Accepted solution]

Hi @Anonymous ,

You can create measure Filter1 like DAX below, then put the Filter1 in the Visual Level Filter of Matrix visual, setting Filter1 as "is not blank".

Filter1 =
var record_2018=CALCULATE(MAX(Table1[Sale]),FILTER(ALLSELECTED(Table1), Table1[Cliente] =MAX(Table1[Cliente])&&Table1[Year]=2018))
var record_2019=CALCULATE(MAX(Table1[Sale]),FILTER(ALLSELECTED(Table1), Table1[Cliente] =MAX(Table1[Cliente])&&Table1[Year]=2019))
return
IF(record_2018<>BLANK()&&record_2019<>BLANK(), 1, BLANK())

Best Regards,

Amy

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

[Anonymous]

It works perfectly, thank you