cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SrinivasB Frequent Visitor
Frequent Visitor

Measure output need to store on new table

Dear Team ,

 

Could you please help on this , I have created few measures in my dataset , i need to store measures output into new table .

 

could you please let me know the process , i will follow the same based on your suggestion .

 

Thank you .

 

Regards,

Srinivas.

2 ACCEPTED SOLUTIONS

Accepted Solutions
hnguy71 Member
Member

Re: Measure output need to store on new table

SrinivasB Frequent Visitor
Frequent Visitor

Re: Measure output need to store on new table

Dear @hnguy71 ,

 

Its worked for me , right now i am able to store the  measures output  from exist table into  new calculated table.

 

This is the method i have followed : 

 

New Table = SUMMARIZE ( Table , Table[Column1] , Table[Column2 ] , "Column Name" , [Measure] )

 

Regards,

Srinivas.

View solution in original post

7 REPLIES 7
Highlighted
SrinivasB Frequent Visitor
Frequent Visitor

Re: Measure output need to store on new table

Dear Team ,

 

Kindly help me on this , please provide me the solution.

 

Regards,

Srinivas.

SrinivasB Frequent Visitor
Frequent Visitor

Re: Measure output need to store on new table

Dear Team ,

 

I am waiting for your kind response .

 

Thank You .

 

Regards,

Srinivas.

hnguy71 Member
Member

Re: Measure output need to store on new table

v-yulgu-msft Super Contributor
Super Contributor

Re: Measure output need to store on new table

Hi @SrinivasB ,

 

Please make your question to be clearer. Do you mean displaying measures in table visual? Or do you mean storing the result of each measure into a table in data view? Or do you want to organize measures with folders

 

Please refer to this blog to provide more detailed information. How to Get Your Question Answered Quickly

 

Best regards,

Yuliana Gu

 

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SrinivasB Frequent Visitor
Frequent Visitor

Re: Measure output need to store on new table

Dear @v-yulgu-msft ,

 

Thank you for your response .

 

i am developing the one report from Dataset1 , and i have created few of measures in Dataset1.

and  here my requirement is i need  store  data from dataset1 to New calculated Table(Dataset2) with the  all columns data , asual with all measures output data  into Dataset2 .

 

storing the result into new table in data view .

 

I hope you are clear about my concern.

 

Please let me know if need clarfication is required from my end.

 

Thank you for your support.

 

Regards,

Srinivas.

v-yulgu-msft Super Contributor
Super Contributor

Re: Measure output need to store on new table

Hi @SrinivasB ,

 

To store all column data, including calculated columns from Dataset1 into a new calculated table is possible with below DAX formula, while it is not possible to store measure values into a calculated table.

Dataset2=VALUES(Dataset1)

Best Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SrinivasB Frequent Visitor
Frequent Visitor

Re: Measure output need to store on new table

Dear @hnguy71 ,

 

Its worked for me , right now i am able to store the  measures output  from exist table into  new calculated table.

 

This is the method i have followed : 

 

New Table = SUMMARIZE ( Table , Table[Column1] , Table[Column2 ] , "Column Name" , [Measure] )

 

Regards,

Srinivas.

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 353 members 3,623 guests
Please welcome our newest community members: