How to filter top N when metric has all values = 0?

[EugenioProlog]

Hello! I'm creating a "Salesman of the month" visual that displays the employee name on a column on my dim table of employees, using a visual filter, that shows the TOP N value based on a metric called [% Real. x Meta Vlr NMRR] 

that calculates de SUM of sales that they made in the current month. But whenever I have a new month, all values on this metric are equal to 0, so my visual displays a random name of a salesman, but i want it to display Blank() or NULL or something else.

How do I adapt my Filter in order to return nothing when all values of my metric are equal to zero?

[rohit1991 · Accepted solution]

Hi @EugenioProlog 

To avoid showing a random employee in that case, you can wrap your measure with a check. For example:

SalesMetricAdj =
IF (
   SUM ( FactSales[Metric] ) = 0,
   BLANK(),
   SUM ( FactSales[Metric] )
)

Or, if you want to check across the whole month:

SalesMetricAdj =
IF (
   CALCULATE ( SUM ( FactSales[Metric] ), ALL ( Employees ) ) = 0,
   BLANK(),
   SUM ( FactSales[Metric] )
)

Now use SalesMetricAdj in your Top N filter instead of the original metric. This way, when all values are 0, the measure returns BLANK, and the visual won’t show any salesman.