Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Solved! Go to Solution.
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!
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.
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.