Forum Discussion
A measure to create a virtual table
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.
3 Replies
- amitchandak
Super User
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
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-msftCommunity Support
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,
KellyDid I answer your question? Mark my post as a solution!
