Row with blank value disappear from table

[Anonymous]

My data model consists of three tables:

• a table with all sales staff
• a table with records of all sales
• a calendar table

When I create a visual with all staff for a sales period Power BI returns 11 names, which is correct:

However, when I add the total sales for the sales people, three sales staff with no sales for the period drop off:

Any idea how I can include these in the table with showing just a blank field for sales? The are currently no filters applied to the visual other than the date of sale.

Thanks

[toucan]

Make sure that the table field is set to don't summarise, otherwise having a blank value will cause the whole row to disappear. 

[amitchandak]

@Anonymous , You can Use +0 and filter for =0

or use this option

[Anonymous]

Thanks for your suggestion @amitchandak. However, the field I was pulling did not show the "show items with no data" option.

[Greg_Deckler · Accepted solution]

@Anonymous - There should be an option to show items with no data. Otherwise, you can often get around this by doing something like this:

Measure =
  VAR __Calc = <Some calculation>
RETURN
  IF(ISBLANK(__Calc),0,__Calc)

[Anonymous]

Thanks @Greg_Deckler, your answer worked like a charm.