Comparing values from 2 different matrix visuals.

[reggiete2005]

Hello All, 

I am needing help trying to write dax logic to compare values between 2 matrixs. Both visuals utilize 2 different data tables. What i am trying to accomplish is comparing the values between both matrixs, to find the variance between them. 

For Example, in the below screenshot, i am trying to compare the values highlighted in yellow. The value in January for the first column/row is 7.39 (FIrst Screenshot) and 3.22(Second Screenshot) for the same column/row headers. I am looking to create a measure and place in a new visual that will show the variance in January for the first column/row would be 7.39-3.22. Same logic would apply for new row, comparing 1.16- 0.29.

Below are the measures used in the matrix screenshots below 

KPI_MarketComparison_OB_DTI_FICOLTV =

IF(

    HASONEVALUE(OB_Market_Data[Fico_Buckets]),

    DIVIDE(

        [KPI_MarketComparison_LockVol],

        CALCULATE([KPI_MarketComparison_LockVol], ALL(OB_Market_Data[Fico_Buckets],OB_Market_Data[LTV_Buckets]))/1.0

    ),

    divide([KPI_MarketComparison_LockVol], CALCULATE([KPI_MarketComparison_LockVol], ALL(OB_Market_Data[Fico_Buckets],OB_Market_Data[LTV_Buckets]))/1.0

))

KPI_MarketComparison_Logan_DTI_FICOLTV =

IF(

    HASONEVALUE(Loan_Details[Fico_Buckets]),

    DIVIDE(

        [KPI_Locks],

        CALCULATE([KPI_Locks], ALL(Loan_Details[Fico_Buckets],Loan_Details[LTV_Buckets]))/1.0

    ),

    divide([KPI_Locks], CALCULATE([KPI_Locks], ALL(Loan_Details[Fico_Buckets],Loan_Details[LTV_Buckets]))/1.0

))

[some_bih]

Hi @reggiete2005 have you already try to connect your buckets (like <600 or Blank...) via relationship? This would be the best

Wanted measure for your case should be simple

Measure diff= [KPI_MarketComparison_OB_DTI_FICOLTV]-[KPI_MarketComparison_Logan_DTI_FICOLTV]