Hi @MickyG ,
Power BI won't calculate the total vaule based on the single values above. In other words, when the regions are expanded, the value of "Austin" isn't calculated based on the values of "Bluff Springs", "Health Professions", and etc.. It is calculated based on the overall max date of "Austin".
For Bluff Springs, per100kWeekend calculate [countyper100k] based on the max date of Bluff Springs.
For Austin, per100kWeekend calculate [countyper100k] based on the max date of Austin.
If I have not made it clear, please tell me your doubts.
Here is an example: Measure Totals, The Final Word - Microsoft Power BI Community
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.