How to I use a Matrix Total, based on a Dynamic Measure, in another measure.

[Rlucero2]

In the Pick below I'm trying to find a way to reference the "Grand Total" amount to be used in another measure. In this case, Specifically, the " ITD Paid Claims Loss Ratio". 

Might look something like this (Net Reserves * ITD Paid Claims Loss Ratio TOTAL= BF NET) The problem is I need this to be dynamic based on the slicers selected.

I tried to make a column, but it's not dynamic, (See Second Pick) 

I feel like I'm missing something simple. Let me know if you have any questions. 

Thank you!

[Ashish_Mathur]

Hi,

I am not clear with your expected result.  Plese clearly show the expected result (may be in an Excel file with your formula so that your logic can be understood).

[Rlucero2]

ya, sorry this was a bit hard to explain. I was trying to break this into two large chunks.

First - Use the Loss Ratio Total, or Average shown in the Matrix to Calculate the BF Net Column. (See Pick, could not attach Excel)

Second - Figure out how to only Average the Rows that are 100% earned. 

[Ashish_Mathur]

How have you calculated column F?  Share the download link of your PBI file and the Excel file (with your formulas intact).

[Rlucero2]

Here is the PBI File. PBI File Example 

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Rlucero2]

Column F is the same as Column E but uses the Average Loss Ratio of the business that is 100% Earned. (only looking at rows 2-10). Excel Example 

I'll start working on making a version of the PBI file that I can share.