Calculate variance between 2 rows in matrix

[mardusd]

Hi Everyone,

I have a simple Matrix, but need to calculate Varaince between 2 Rows per month on the matrix.

I created the below:

ConvAmount % difference from Potential Collections =

VAR __BASELINE_VALUE =

    CALCULATE(

        SUM('CRM'[ConvAmount]),

        'CRM'[Heading] IN { "Potential Collections" }

    )

VAR __MEASURE_VALUE =

CALCULATE(

        SUM('CRM'[ConvAmount]),

        'CRM'[Heading] IN { "Actual Collections" }

)

RETURN

    DIVIDE(__MEASURE_VALUE - __BASELINE_VALUE, __BASELINE_VALUE)


The result is however not per month, but only the totals of the rows are used in the calculation. How can I calculate per month?

[amitchandak]

@mardusd , this formula seems correct. where you have used this.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[mardusd]

The major issue is it is not grouping per month, it only uses the total and does the calculation as per the total

[v-jingzhang]

@mardusd What visual is the measure put in? Is there any month filter in its calculation context? Can you please show a screenshot of the current result and expected result?

Best Regards,
Community Support Team _ Jing Zhang