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...
Are you saying that then I would another measure
Measure 1 End Company A = Calculate(sum(column[revenue]), End Company = "A")
then I would add Measure 1 + Measure 1 End Company A = total revenue of Company A?
HenriqueReis
Resolver I
Resolver IIm not sure if it's what you want, but by what I understood, it's going to work rsrs
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]))returntest+test2Thank you so much!!