Hi,
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
Solved! Go to Solution.
Hi @Mape94 ,
see my pbi file
https://1drv.ms/u/s!Aj45jbu0mDVJiHfRIaja1FReNxxK?e=ZaQeNt
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Mape94 ,
see my pbi file
https://1drv.ms/u/s!Aj45jbu0mDVJiHfRIaja1FReNxxK?e=ZaQeNt
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
119 | |
75 | |
66 | |
51 | |
49 |
User | Count |
---|---|
180 | |
96 | |
79 | |
77 | |
74 |