A measure to create a virtual table

[RCS3]

Hi everyone!
I'm trying to visualize few selected columns from the data set using a measure. but I don't know how to do it properly. I used SUMMARIZE function as shown in the screenshots, but since it needs an expression I'm not able to grab the required columns. Any suggestions?

NOTE: The reason for my requirement is I need to visualize the selected columns based on a single date on the date slicer which I achived to do using a calculated item. But this only works if a measure is linked with it.

[amitchandak]

@RCS3 , refer these examples and my video

sumx(summarize(Table, Table[country], Table[city], "_1", CALCUALTE(Max(Table[Value]))), [_1])

mRequiredQty =
SUMX(filter(
SUMMARIZE(qryBOMData,qryBOMData[HeightGauge],qryBOMData[Width],
"TotQty", [mSales]-[mStockQty]),
[TotQty] >0
),[TotQty]
)

Summarize - https://www.youtube.com/watch?v=qE5KBp4uP0g

[RCS3]

Hi Amith,
Thanks for the quick prompt. Unfortunately I don't think your solution works niether the provided video. (Or may be I don't understand your solution since I'm a newbie to this subject).
My requirement is to create a virtual table using a measure which shows only specific columns from the data set on to matrix. none of the table manipulation functions works on measure that's the reason I used SUMX function, but it needs and expression to operated properly. I need a solution to overcome this issue.

Thank again.

[v-kelly-msft · Accepted solution]

Hi @RCS3 ,

Check my sample table below:

Whether below summarized table is what you need?

If not,would you pls provide some sample with expected output for test?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!