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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
SamfarUK
Regular Visitor

Struggling with a variance/difference column in table visual

I have three tables whereby i have an actual percentage and a target percentage. I want a final column to show me the difference between the actual percentage and the target percentage. I am not having much luck. Can someone please help?

 

Here is a snippet of my report :

SamfarUK_0-1699453665421.png

You can see the measure I have built for the difference. 

2 REPLIES 2
amitchandak
Super User
Super User

@SamfarUK , If Both % are measure, you measure should be like

 

[M1] - [M2]

 

If they are not then calculate a measure like below using base columns

Divide(Sum(A), Sum(B) )  - Divide(Sum(A1), Sum(B1) ) 

Thanks for your response.

 

If using the first table as an example, Overweight [%] is a measure but Target is not. 

 

I am relatively new to Power BI and still learning; I don't quite understand what your base column solution is. If you wouldn't mind elaborating on this process. 

 

Thanks,

Sam

 

 

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.