"Force" a value from different IDs

[coliveira03_]

Hello,

I have two sittuations

1) first table is called "master", contains unique ID (folder No), and business area = "Tour Op Sports"

the second table, has many different IDs - they are sales - and business area is <> "Tour Op Tour"

they have in comun the product name

What I need is to create a new column in the second table, where the rows show me the "master ticket cost unit", in this case, 355€

I need to "force" this value in the column - I have tried many ways, the totals work fine, the problem is per row on the table and i have to do further calculations that dependes on these values

Let me know if needed futher explanation, Is confused to explain

I relly appreciate any help or input

Thank you

[v-yueyunzh-msft · Accepted solution]

Hi , @coliveira03_ 

According to your description, you want to add a column in Table2 visual in Table1 [Master Ticket Cost Unit].

You can try to create a measure like this:

Measure =  var _t =ADDCOLUMNS( SUMMARIZE('Table1','Table1'[Folder No],'Table1'[Event Name]) , "Master Ticket Cost Unit", [Master Ticket Cost Unit])
return
MAXX(_t, [Master Ticket Cost Unit])

The _t is the virtual table to simulation your Table1 filter context to get the [Master Ticket Cost Unit].

And in the last we use the MAXX() function to get the max of the [Master Ticket Cost Unit] , and in your case is $355.

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem. (You can also upload you sample .pbix [without sensitive data] to the OneDrive and share with the OneDrive link to me ! )

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly