Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Win a FREE 3 Day Ticket to FabCon Vienna. Apply now

Reply
hjoshi4u26
Regular Visitor

Calculate Average of Variance for Card Visual

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

hjoshi4u26_0-1684229928092.png

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 🙂
0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.