Forum Discussion
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"(this column is in table 3) slicer . When i drive data using city I get wrong percentages. Note-Percentages does not add up to 100% so i cannot use %to grand total as well.
Calculation of percentage: created calculated column in table 1 "per" by taking numerator from table 1 and denominator from table 2.
Requirement is: when I select particular city calculation should take values of the city upon total of that city.
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.
2 Replies
What's the relationships between these three tables? Can you share some sample data and your expected result?
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.
