Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 ) )
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 ) )
@flemingg62 Flip your relationship direction to "Both"?
Hi as somone new to Power BI is that a solution or just a comment?. if a solution can you please expand.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |