I’m trying to calculate my total Customer Sales for the month and having multiple No Sales Customers:
Sales = DIVIDE( [Revenue 000’s], 1000)
All Customers = COUNTROWS( ALL( ‘Ship-To Party’[Ship-To Party (Key)]))
Total Customers = DISTINCTCOUNT( ‘Ship-To Party’[Ship-To Party (Key)] )
Factual data is coming from SPP CS Reallocation table with relationship to Ship-To Dimension table based upon Ship-To, see below:
Any support here isolating the No Sales Customers will be highly appreciated.
Thanks a lot,