Forum Discussion

SamfarUK's avatar
SamfarUK
Icon for Helper I rankHelper I
2 years ago

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 :

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

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    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) ) 

    • SamfarUK's avatar
      SamfarUK
      Icon for Helper I rankHelper I
      2 years ago

      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