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

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.