How to put a measure into a table

[Anonymous]

Good afternoon

I have a table called MyTSR, which has two columns. TSR and MYAILabel. 

I need to create a table with the rows associated with MyTSR[TSR] and three columns with individual measures, called last 7 days, last 7 days positive, and Long Trend. 

I have tried to use summarize and calculated tables, however, I think i am getting this wrong.

The table should look like

MyTSR	7DayCount	7DaysPositive	LongTrend
A	text based on Last 7 days	text based on last 7 days positive	Text based on Long trend
B	as above	as above	as above
C	as above	as above	as above

This is my dax code that i know i am butchering

MyTSRTable =
SUMMARIZE (
'TSRTable',
"ID", 'MyTSR'[TSR],
"7DayCount", [Last 7 Days],
"7DayPositive", [Last 7 Days Positive],
"LongTrend", [Long Trend]
)

Please can you give me some pointers as to how to do this properly?

The values are stored in a table as I have a table that I am using as a reference, and i need to do an AND calculation per row.

I hope that this helps you to help me with this.

I look forward to and will be grateful for any assistance

Lola

[Anonymous]

@Jihwan_Kim Thank you for this solution. It does work as required and I am grateful for your response. Have an amazing day.

Lola

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, but please try something like below.

MyTSRTable =
ADDCOLUMNS (
    VALUES ( 'MyTSR'[TSR] ),
    "7DayCount", [Last 7 Days],
    "7DayPositive", [Last 7 Days Positive],
    "LongTrend", [Long Trend]
)