Forum Discussion

tc5613213's avatar
tc5613213
New Member
5 years ago
Solved

Counting from another table that matching same columns from this table

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 00...
  • tc5613213's avatar
    tc5613213
    5 years ago

    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]
    )
    )
AntrikshSharma's avatar
AntrikshSharma
Icon for Community Champion rankCommunity Champion
5 years ago

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

tc5613213's avatar
tc5613213
New Member
5 years ago

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]
)
)