Create Table based on columns and measures

[EvertonRosa]

Community, I need a little help!

Is there any way to create a table based on a column and a measure? Let me explain the case:

I have a PRODUCTS table with a column called family_name. Each product has its own family. Ex:

product	family_name
1	AAA
2	AAB
3	AAC
4	AAD
5	AAE

I have a measure that CALCULATE the Time to Win for each opportunitie on table OPPORTUNITIES. Ex: 

Time to Win (Family) =

CALCULATE(

    AVERAGEX(

        SUMMARIZE(

            FILTER(fOportunities,fOportunities[statecode] = 1),

            fOportunities[opportunityid],

            dProducts[family_name],

            "AvgDays",MAX(fOportunities[DaystoClose])

        ),

        [AvgDays]

    ),

    USERELATIONSHIP(dCalendar[ID Data],fOportunities[actualclosedate])

)

Now, I wloud like to generate a table like this: 

family_name	Time to Win
AAA	5
AAB	10
AAC	15
AAD	20
AAE	25

I have tried to aproach using SUMMARIZE, ADDCOLUMN but I couldn´t figure out how to do it. Any help?

[amitchandak · Accepted solution]

@EvertonRosa , if you create calculated table, the measure can not take slicer value and calculation may not go as planned and will be static

Add a new column, using addcolumns, and use related , relatedtable, or simple max function work across the table

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

[EvertonRosa]

Thanks, @amitchandak. I found a solution after watch your videos. 

[aditya0125]

Create calculate column and use either Related or RelatedTable function.