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...
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!!