I am trying to create a measure that shows the number of stores with zero sales.
Number of Stores = DISTINCTCOUNT(Query[Store_Number])
PP Units = SUM([PP_Units])
Zero Sales Stores = IF([PP_Units]<1,1,BLANK())
% of Stores =DIVIDE([Zero Sales Stores],[Number of Stores],0)
Power Pivot table name = Query
I cannot get any of the measures that I tried to create to add up to 8 in the subtotal for district or territory. Also, I will be adding Digital Service Orders to this table and I will need to count the number of stores without orders. 
