Forum Discussion
Matrix visual to show rows without values
Hi, I'm trying to create a matrix visual that shows all customers even if they don't have any sales figures. And I want it to work with a date slicer. The vision I'm trying to reach is something ...
ErikHolmberg First create a relationship between the Client ID in the customer table and the Client ID in the sales table.
Create a measure to sum the sales amounts
Total Sales = SUM(Sales[Amount])
To ensure that all customers are displayed even if they don't have sales, you need to modify the measure to handle cases where there are no sales.
DAX
Total Sales with Zero =
IF(
ISBLANK([Total Sales]),
0,
[Total Sales]
)
Use this measure in matrix
Thanks for the quick answer!
What I'm not quite getting is how I with this will be able to divide the the sales per Business Area, sorry if that wasn't clear in the original post