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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Anonymous
Not applicable

Total sales if a center has been visited in a date threshold

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

1 ACCEPTED SOLUTION
mangaus1111
Solution Sage
Solution Sage

Hi @Anonymous ,

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.

View solution in original post

1 REPLY 1
mangaus1111
Solution Sage
Solution Sage

Hi @Anonymous ,

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.

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors