Measure to calculate

To create the measure you need in Power BI, you want to count the number of outlets that have contracts regardless of sales by target product or other products. Here is a DAX approach:

Assuming your table name is SalesData:

1. Number of contracted outlets (regardless of product sales):

    

   ContractedOutlets =

   CALCULATE( DISTINCTCOUNT(SalesData[OutletID]),

   SalesData[Contract] = "y" )

   1. Number of outlets with sales on selected dates for target products only:

      Make sure you have a Date slicer or filter that limits SalesDate to your 4 selected dates.

       

       

      OutletsWithSales_TargetProduct =

      CALCULATE( DISTINCTCOUNT(SalesData[OutletID]), SalesData[TargetProductFlag] = "y", SalesData[SalesDate] IN VALUES(SelectedDates[Date]) // Assuming SelectedDates is your date filter table )

      1. Create a table visual with Area, Target Product Flag (filter to "y"), and these two measures.

         This way:

         • Contracted outlets count is independent of sales/product.

         • Sales count is filtered on target products and selected dates.

         • Area is in rows for grouping.

           If your date selection is via slicer/filter, the second measure automatically respects that.

           This approach will give you correct counts per Area as needed.

         •  

         •