How to show all values from a column that is being filter by a measure

[krist_pbi]

Hey

This should be simple but don't know how to solve it. I have a sales table and a dimensional Client table, in the sales table I have the  column ClientName as foreign key and Total Sales as measure, when using the column ClientName from dim Client table and  the Total Sales measures from Sales table in a table view, it only shows the Clients with sales records, is there a way I can show ALL clients regardless they have sales records or not? I'd like to show zero for the ones with zero sales

[Uzi2019]

Hi @krist_pbi 

yes you are getting correct result. as only client with sales value are displaying .

if you want to have all client then you have to modify your measure value by adding +0 to your measure.

New Total Sales= [Old Total sales] +0 

It will give 0 against all client which sales are not present.

I hope I answered your question!

[SamWiseOwl]

Hi @krist_pbi 
You can either edit your existing measure or create a new one.

Measure to show 0 =

var s = [Your calculation or measure here]

Return
IF( isblank(s), 0, s)

Alternatively you may be able to just add 0 to the end of your measure.

Your measure =
SUM(table[column]) + 0

Finally if you want to show the row as blank, you can click the column in the visual and choose show items with no data.

[krist_pbi · Accepted solution]

This works, thanks a lot!

[SamWiseOwl]

Great 😁 if you could mark it as a solution for others to find, thank you!