Forum Discussion
mwadhwani
9 years agoKudo Kingpin
Calculation with Percentage
Hi Experts, I am a beginner in power bi. I have two tables table1 and table2 . And i want to calculate percentage with numerator from table1 and denominator from table 2 . Also I have one "city"(...
- 9 years ago
Hello v-sihou-msft
Relationship: Table 1 - Table 2 (Many to one)
Table 1 - Table 3 (Many to one)
I got the solution for above problem by creating measure.Measure calculates percentages dynamically.
v-sihou-msft
9 years agoMicrosoft Employee
What's the relationships between these three tables? Can you share some sample data and your expected result?
mwadhwani
9 years agoKudo Kingpin
Hello v-sihou-msft
Relationship: Table 1 - Table 2 (Many to one)
Table 1 - Table 3 (Many to one)
I got the solution for above problem by creating measure.Measure calculates percentages dynamically.