I have a simple situation here, but can't figure out how to solve it. Imagine the following data model:
What I need is a measure (or maybe a column?) that shows the sum of Hours when the Project Company is different from the User company. I tried this:
Intercompany Hours = CALCULATE (Sum(Hour[Hours]);Project[Company]<>User[Company])
It does not work... I would appreciate any help!
Solved! Go to Solution.
i dont think your data is modelled correctly. Firstly how are the joined together? you need some kind of unique id that flows through to all tables ie. both project and user s should have a project id? or is that link there?
Hi David and Vanessa,
Here is a link to my example file: http://www.syscope.com.br/files/example.zip
Here is the data model:
Here is the data, my expression should show the 10 hours below (where the user company is different from the project company):
This is the error I got with my formula:
And David, this is the error I got from your formula:
It’s time for another PBI Community recap!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!