cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bo_wang5
Helper II
Helper II

Sales data available at different levels

I have 2 data sources of sales data.  I did not merge the datasets so I have a sales data from one source and sales data from the other as two separate columns from two seperate tables.  In data source 1, the customer's name and city are available.  However, in Data source 2, there is no cusomter name information, I only have city and total sales.  Is there a way when the 2 source of data are put into to a matrix visual to not show the exact same value when the data is from data source 2?  So i still want the display to show a city level total for Data source 2 but not have that display for each customer since that data does not exist at the customer level in data source 2.

 

bo_wang5_1-1630886383172.png

 

 

bo_wang5_0-1630886003081.png

 

1 ACCEPTED SOLUTION

Thank you, I acutally used an 

if(isfiltered('Data Source 1'[Customer Name]),blank(),sum('Data Source 2'[Data source 2]))
for the visual, it seems to work.

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@bo_wang5 , Create a common city table and you can join both tables with that.

 

Also, you can create a customer table with additional row ( Enter Data, Append query in power query) having id -1 or name all , and add that as an additional column in not having customer(id _1 or Name all) .

 

Not join both table with customer and analyze the a data across.

 

Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Thank you, I acutally used an 

if(isfiltered('Data Source 1'[Customer Name]),blank(),sum('Data Source 2'[Data source 2]))
for the visual, it seems to work.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.