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
Highlighted
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.

7 REPLIES 7
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.

Highlighted
hnguy71 Member
Member

Re: Measure output need to store on new table

Community Support Team
Community Support Team

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.

Community Support Team
Community Support Team

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.