Forum Discussion
flemingg62
Helper I
Helper ICan't Sum to linked tables
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 th...
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
Community Champion
Community Championflemingg62 Flip your relationship direction to "Both"?
flemingg62Helper I
Helper IHi as somone new to Power BI is that a solution or just a comment?. if a solution can you please expand.