PowerPivot (New Measure - Formula)

[MAMatheen]

I have three tables in which one column contains the Product names. All three sheets contain different names, multiple times.
Sheet1 Sheet2 Sheet3
Pro. Name Pro. Name Pro. Name

Product A Product 1 Product AA1
Product B Product 2 Product BB2
Product C Product 3 Product CC3
Product D Product 4 Product DD4

I need all products displaying onces using New Measure method.

Can you please help me out in this.

 

[SirJB7]

Hi, MAMatheen!

As a new user you might want to (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you, relieving the contributor of having to build a test file, if necessary. Thank you.

Regards!