topic Re: DAX % of Grand Total from Variable in DAX Commands and Tips

DAX % of Grand Total from Variable

jodyclaggett — Mon, 24 May 2021 21:11:22 GMT

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?

Re: DAX % of Grand Total from Variable

Greg_Deckler — Mon, 24 May 2021 21:52:07 GMT

jodyclaggett Could you just do this?

DisplayItem = 12, Over90 / EatbTotal,

Re: DAX % of Grand Total from Variable

jodyclaggett — Tue, 25 May 2021 02:15:21 GMT

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.

Re: DAX % of Grand Total from Variable

jodyclaggett — Wed, 26 May 2021 14:35:52 GMT

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: