Counting from another table that matching same columns from this table

[tc5613213]

Hi, new to power bi and try to learn from hands-on task.

Sample data:

Table 1 sample data (source data):

User_ID	Time_date	App_Category	loc_Type
0	001	'Music'	'Residence'
0	002	'Music'	'Hotel'
0	003	'Travel'	'Restaurant'

Table 2 (created from the visulasation page, cross join from 2 columns from the different table)

App_Category	loc_type
Music	Residence
Music	Hotel
Music	Resturant
Travel	Residence
Travel	Hotel
Travel	Resturant

What I want to archieve is to add a count column that count the number of ourrance of both columns in table 2 in table 1:

App_Category	loc_type	Count
Music	Residence	1
Music	Hotel	1
Music	Resturant	0
Travel	Residence	0
Travel	Hotel	0
Travel	Resturant	1

Can anyone give me a hint on how to do it? Thanks!

[AntrikshSharma]

@tc5613213 Should be easy, can you share the mock up pbix file of the sampel data as well. 

[tc5613213 · Accepted solution]

Thank you for your response, I figured it out after reading a few related post. If anyone is wonder, this is my solution:

Count =

CALCULATE(

COUNTROWS(App_usage_trace),

FILTER(

App_usage_trace,

App_usage_trace[Base_station_type] = 'POI and App Cate'[Most_POI] &&

App_usage_trace[App_Category] = 'POI and App Cate'[App Category]

)

)