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.

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
4 years ago

JohnYEG 

This measure should work for you:

 

Revenue A = 
VAR __CO = "A"
RETURN
CALCULATE(
    SUM(Table[Revenue]),
    (Table[Billing Company] = __CO || Table[End Company] = __CO) 
)