Partner Count

Hi, Anonymous 

Based on the information you have provided, Here are my answers to your questions.

1. First you can create a table.

2. Then create a Measure. This method is designed to display the New Customer and Lost Customer.

Measure =

     VAR Customer2023 =

          CALCULATE(SUM('Table'[Amount]), FILTER('Table', 'Table'[Year] = 2023))

     VAR Customer2024 =

          CALCULATE(SUM('Table'[Amount]), FILTER('Table', 'Table'[Year] = 2024)

RETURN

 IF(Customer2024=0&&Customer2023<>0,"Lost",IF(Customer2024<>0&&Customer2023=0,"New"))

3. Finally you get New Customer and Lost Customer.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Yilong Zhou

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