Calculation with Percentage

[mwadhwani]

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.

[v-sihou-msft]

@mwadhwani

What's the relationships between these three tables? Can you share some sample data and your expected result?

[mwadhwani · Accepted solution]

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.