Forum Discussion

RCS3's avatar
RCS3
Frequent Visitor
5 years ago
Solved

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 ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    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!

RCS3's avatar
RCS3
Frequent Visitor
5 years ago

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's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
5 years ago

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!