Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Find the Purchased/Unpurchased Outlet

Dear BI Community Team,


I have 02 tables --- sales order & customer that want to find the customer purchased and unpurchased from customer.


I have created the measure of Total Sales = SUM('Sales Order'[Amt No VAT]) and after trying, it is showing the customer purchased only and missing of unpurchased.


Sample pbix file -- 


Expectation result:




Any suggestion? 


Thanks and Regards,


Community Support
Community Support

Hi @ADSL ,


Could not reach the file.

Could you please share the data in text format in this post?


Best Regards,


Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Hi @v-jayw-msft,


Please kindly try and check it again -


Thanks and Regards,


Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.