Forum Discussion

Rlucero2's avatar
Rlucero2
Frequent Visitor
4 years ago
Solved

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

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 somethin...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

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's avatar
Rlucero2
Frequent Visitor
4 years ago

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's avatar
    Ashish_Mathur
    Super User
    4 years ago

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

    • Rlucero2's avatar
      Rlucero2
      Frequent Visitor
      4 years ago

      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. 

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        4 years ago

        Hi,

        You may download my PBI file from here.

        Hope this helps.