How to filter by customers that added a sales type

[ZachPLPI]

I am trying to figure out how to filter a visualization by only customers that added a new sales type. My columns are client, sales $, sales type, year. I only want the clients that went from 1 to 2 types, 1 to 3 types, or 2 to 3 types. I know how I would do it in excel. I would say countifs(or(sales type = Sales Type A, Sales Type = Sales Type B, sales type = Sales Type C), year = 2017),1,0). Then I would do the var between 2017 and 2018 and say if 2017 > 0 and 2018 count - 2017 count > 0, Then result. 

I am lost on how to do that with DAX. 

[PaulDBrown]

Could you please provide a sample dataset or PBIX file, and a depiction of the expected output? Thanks

[ZachPLPI]

The error message "PBIX file is not supported" popped up. But I can manually write that out.

Customer Name          Sales Type               Year              Sales

A High                          Type A                    2017             100

A High                          Type A                    2018             100

A High                          Type B                    2018              50

B High                          Type A                    2017              50

B High                          Type A                    2018              50

B High                          Type A                    2019              50

So I want to be able to show the total sales per sales type by year for clients like Client A (Added a sales type) and client B (Did not add a sales type).

[v-deddai1-msft]

Hi @ZachPLPI ,

Would you please show us the expected output based on your sample data?

Best Regards,

Dedmon Dai