Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
krist_pbi
Frequent Visitor

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

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

1 ACCEPTED SOLUTION

This works, thanks a lot!

View solution in original post

4 REPLIES 4
Uzi2019
Super User
Super User

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!

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
SamWiseOwl
Super User
Super User

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.

SamWiseOwl_0-1731451236514.png

 


If you are happy with this answer please mark as a solution for others to find !

Kudos are always appreciated! Check out our free Power BI video courses.

This works, thanks a lot!

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


If you are happy with this answer please mark as a solution for others to find !

Kudos are always appreciated! Check out our free Power BI video courses.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!