Can't Sum to linked tables

[flemingg62]

Hi

New to Power BI and moving some reports from Access

I have 2 tables one with Data and one a reference table

The linked filed is Queston Code

I want to sum how may utilised there are by Survey Type

But it is only summing how may time it occurs in the reference table (BI_Activities), see below, How can I calculate how many times it matches with the main data (BI_SurveyData)

When I run the query on access

[tamerj1 · Accepted solution]

hi @flemingg62 

you can use a measure that CROSSFILTER the relationship to 2way
Total Utilized = 

CALCULATE ( SUM ( BI_Activitie[Utilised] ), CROSSFILTER ( BI_Activities[Question Qode],BI_SurveyData[Question Qode], BOTH ) )

[Greg_Deckler]

@flemingg62 Flip your relationship direction to "Both"?

[flemingg62]

Hi as somone new to Power BI is that a solution or just a comment?. if a solution can you please expand.