Hello 🙂 I have a powerbi report which shows the unit size of the product as shown below:

Here the Variance Table is populated by using multiple Measures:
Measure Total size = SUM('Product Size'[Size in Unit])
where 'Product Size' is Table and [Size in Unit] is a Column
Measure Previous Month size = CALCULATE([Total size], PARALLELPERIOD('Calendar Table'[Date].[Date], -1, MONTH))
Measure Variance = IF(OR(ISBLANK([Previous Month size]), ISBLANK([Total size])), BLANK(), ABS([Total size] - [Previous Month size]))
This table calculates the variance compared to Previous Month. I have used the ABS function to get the Absolute Value (I do not require +ve or -ve sign) and I have also used an IF condition to remove the unwanted initial high value of the variance.
I have also created a relationship between a Calendar Table and Sales Table, hence used 'Calendar Table'[Date].[Date] in PARALLELPERIOD Dax.
I have populated the Trendline graph with it and also added the Average Line using 'Add Further Analysis' feature. I also need to display the Average of Variance in a Card Visual. Can anyone please help me in this..? I am not able to get the Average of Variance in Card Visual. Any help will be appreciated 🙂