Forum Discussion
Solved
Create a measure from summing from two separate columns (if client occurs in either column)
Looking to see how I can create a measure that is able to track the revenue of a Client if it occurs in either column. For example I would like to record the revenue of Client A on whet...
ah okay, for that example company A, I can't just add those 2 columns together. What I would like is how do we add a condition where I don't double count. For example on Contract 3, Company A is both Billing and End but I only want to count it once.
Hi try this it sould work
total revenue =
var activproj=SELECTEDVALUE(Billing[end company])
var test=calculate(sum(Billing[revenue]),(Billing[billing company]=activproj))
var test2=if(AND(SELECTEDVALUE(Billing[billing company])<>activproj,SELECTEDVALUE(Billing[end company])=activproj),SUM(Billing[revenue]))
return
test+test2
Thank you so much!!