Ill simplify the model with which im working. I have the following two tables:
A table with three colums that collect data of total sell out per center and day: center, total sales, day.
The second table contains a line only if one of theese centers have been visited, and the day of visit: center, date.
So, I want to calculate Total Sell out in visited and non visited centers, depending on a date slicer. If I select "january" and no center has been visited that month, total sell out for visited center in january should be 0 and total sell out for non-visited centers in january should be xxxx$.
Sorry, cannot share the pbi cause the data is private.
Thanks a lot