DAX % of Grand Total from Variable

[jodyclaggett]

I need help calculating the % of grand total based on a variable calculation in an asymetical matrix. 

Here is my table values that I need to calculate on:

Essentially, I need to divide 834655.70/69945935.43 striped across the entire table to get what percentage of the over 90 that is in the total grouping. The problem I'm having is that I'm using variables to create these columns, in an asymetrical matrix and there doesn't seem to be a way to strip the grand total (69945935.43) across the entire grouping to then use that value in a DIVIDE funcation. SUM and SUMX both look for a table, but I'm using a variable. Do I need to create a table from my variable and if so, how do I do that?

Here's my code to calculate the columns:

EatbTotal is the variable that contains the grand total (denominator) and Over90 is the numerator. 

Any ideas how I can do this?

[jodyclaggett · Accepted solution]

So, I actually figured this out. I had to create a seperate measure entirely that striped the total by group across the column and then use that measure in my variable calculation. 

And then in the Values to Display measure:

[Greg_Deckler]

@jodyclaggett Could you just do this?

DisplayItem = 12, Over90 / EatbTotal,

[jodyclaggett]

That gives me % over 90 for the row, but not the grand total for the Total column.  That is effectively Total/Over 90 Days whereas I need the Grand Total of Total/Over 90 days.