Calculation based on values from different rows and columns

[Anonymous]

Hi

I have a list of Jobs, that each consists of a list of JobTasks.
Now I want to do calculations on values from 2 different Job_Task_No (6999 & 7499), with values placed in different columns.

(profit %, difference etc.)
I just can't get my head around this ..... 😥

Suggestions? 

Thanks in advance!!

[v-gizhi-msft · Accepted solution]

Hi,

Please try this measure:

Measure = 
var a = CALCULATE(MAX('Table'[Usage_Total-Cost]),FILTER('Table','Table'[Job_Task_No]=6999))
var b = CALCULATE(MAX('Table'[Contract_Total_Price]),FILTER('Table','Table'[Job_Task_No]=7499))
return
a+b

The result shows the sum of two columns values where Job_Task-No is 6999 and 7499:

Here is my test pbix file:

pbix 

Hope this helps.

Best Regards,

Giotto Zhi

[Greg_Deckler]

Not quite sure. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490