Forum Discussion

JohnYEG's avatar
JohnYEG
Frequent Visitor
4 years ago
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...
Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

HenriqueReis's avatar
HenriqueReis
Icon for Resolver I rankResolver I
4 years ago

Hi,

 

You can create measures and manipulate them, like:

 

Measure 1= Calculate(sum(column[revenue]), Billing company = "A")

Measure 2= Calculate(sum(column[revenue]), Billing company = "B")

Measure 3= Calculate(sum(column[revenue]), Billing company = "C")

 

And then make another measures using Measure1, 2 and 3.

 

Regards!

JohnYEG's avatar
JohnYEG
Frequent Visitor
4 years ago

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's avatar
    HenriqueReis
    Icon for Resolver I rankResolver I
    4 years ago

    Im not sure if it's what you want, but by  what I understood, it's going to work rsrs

    • JohnYEG's avatar
      JohnYEG
      Frequent Visitor
      4 years ago

      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.

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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