Show $0.00 Sales to a customer by a saleperson based on TOP N

[Oros]

Hello,

Is there a way to also show if sales of a selected salesperson has $0.00 sales to his assigned customers, based for each of the TOP N items?  Each Salesperson has his assigned customers.

Here is the illustraion for details.  Thanks.

[v-easonf-msft · Accepted solution]

Hi， @Oros 

Yes,and you  can also  try to create a new measure  as below  to replace your original  field "Sales"

Measure_Sales =
SUM ( 'Table'[Sales] ) + 0

Best Regards,
Community Support Team _ Eason

[Oros · Accepted solution]

It worked!  Thanks.

[Greg_Deckler]

@Oros Well, you could construct your sales measure like the following:

Sales = 
  VAR __Sales = SUM('FactTable'[Sales Amount])
RETURN
  IF(ISBLANK(__Sales),0,__Sales)

[Oros · Accepted solution]

THANKS!!! It worked too!

[Oros]

Hi Greg,

Thank you for your reply.

Do I change the __Sales in the Return line?

[v-easonf-msft · Accepted solution]

Hi， @Oros 

Yes,and you  can also  try to create a new measure  as below  to replace your original  field "Sales"

Measure_Sales =
SUM ( 'Table'[Sales] ) + 0

Best Regards,
Community Support Team _ Eason

[Oros · Accepted solution]

It worked!  Thanks.