Count Measure Results in Summarized Table in Matrix Visual

Anonymous thank you for your interest!

When I was writing up the original post I was thinking about how I could supply some sample data but the model is just so large and complex that I couldnt think of a reasonable way to do it. For example, the measure [Total FOCUS Rating] is the sum total of total lines from 5 different tables that are precomputed at refresh time.

So, what part of this would you like me to try to create data for? 

If it helps here is the relationional diagram for this calculation.

Red are precomputed tables that each contain a final total score/rating by property by month.

Blue is the table that contains all combinations of property and month.

Green is the dimension table that contains the effective dates of management by property, vice president, and manager. All three of these values have significant impact on what data is being computed.

Also, like i said in an update, the second code with the SUMX is functioning now but it is running very slow and the row total shows 0 instead of counting the sum of the letter grades for each individual person.