How to find a difference between two percentage columns in power bi

[Anonymous]

Hi All,

Kindly help me in getting the difference between two percentage columns (highlighted "cal util - tar util" )as mentioned in the attachment.

Attaching some junk file which i need to get differnce based on the file and it should not impact accuarcy even when i apply filters on the data.

https://drive.google.com/file/d/1XWB4cLAh6FYQe_c-t-Mlc61f03nGm9gi/view?usp=sharing

[v-lili6-msft]

hi, @Anonymous 

If [cal util] and [tar util] are measure, you could add a measure as below:

cal util - tar util = [cal util ] - [ tar util]

If  [cal util] and [tar util] are columns, you could add a measure as below:

 cal util - tar util =  SUM('Table'[cal util]) - SUM('Table'[tar util])

Best Regards,

Lin

[Anonymous]

Hi @v-lili6-msft 

Cal util is a measure and tar util is a default column

Now suggest me how can i find the difference between them.

when i write above formula which you have provided it is not working correctly. Please find below the screenshots.

[v-lili6-msft]

hi, @Anonymous 

Could you share your simple sample pbix for us have a test?

Best Regards,

Lin

[Anonymous]

Hi @Anonymous ,

Did you try using Quick Measure? these steps below:

In the field panel, right click -> Hit on New quick measure->  pop up window appears, scroll down to the subtraction-> drag the values you want to use for your calculations

It should resolve your issue.

My output with quick measure:

Or

Measure to use:

Variance = 
SUM('Sheet1 (2)'[cal util]) - SUM('Sheet1 (2)'[tar util])

Let me know if this works.

Thanks,

Tejaswi