Hello Folks,
I created a Matix that counts the number of Tiers by Area by Month. lets say I have 3 types of Tiers, 14 Areas, 6 Months worth of data, and thousands of accounts with those information in a table. So my table has 14 rows for 14 areas, 6 columns for 6 months, and the values are the count of Tiers of those accounts for each area in each month.
now I want to divide those values (Count of Tiers) by another number in a different table to get a percentage. this table has the number of total accounts within each area which comes from a different source (I can't get the total by adding the accounts in the first table). these 2 tables has a one to many relationship connecting to each other by the Area.
I created a measure ( Measure = COUNT(Query1[Tier])/SUM(Sheet1[Number of Account]) but unfortunately I get a wrong answer!
Ideally I want to have a table that I can put Areas in rows, Months in columns and my calculated measure in Values that shows the correct percentage.
Could you help me write this measure?
