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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.