Power BI- DAX Formula or Temp Table?

I am trying to build a DAX formula for a PBI table visual (i.e, not a matrix), or maybe I need a virtual table to help, but I have a visual that has columns A, B, and C in the attached image.  I need to add Column D to the visual; i.e, the % of Total for each month.  This would be simple, but note that the Total line for each month is derived in the SQL statement (through a UNION), so 'Total' is a value in the Status column.  I have created a virtual table that shows the totals for each month, but when I join to the real table, it's a 1 to many, so the numbers get inflated.  I would like to create a DAX formula instead of a temp table to do this.  I tried doing CALCULATE(SUM(Table[Total Issues]),Table[Status]="Total" && Table[Reporting Month]=EARLIER(Table[Reporting Month])).  This does give me the correct denominator total value that I can apply to each month, but it only applies it to the rows where the status is 'Total'.  I need it to be applied to all the rows within the month.