Calculate Average of Variance for Card Visual

hjoshi4u26 — Tue, 16 May 2023 09:51:23 GMT

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 🙂

topic Calculate Average of Variance for Card Visual in DAX Commands and Tips

Calculate Average of Variance for Card Visual