Measure output need to store on new table

[Anonymous]

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.

[hnguy71 · Accepted solution]

Here's a good start:

https://docs.microsoft.com/en-us/dax/summarize-function-dax

[v-yulgu-msft]

Hi @Anonymous ,

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

[Anonymous]

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]

Hi @Anonymous ,

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

[Anonymous]

Dear Team ,

I am waiting for your kind response .

Thank You .

Regards,

Srinivas.

[hnguy71 · Accepted solution]

Here's a good start:

https://docs.microsoft.com/en-us/dax/summarize-function-dax

[Anonymous · Accepted solution]

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.

[Anonymous]

Hi, did it done realy wha tyou wanted? i tried that but it recalculate the result on every refresh. I would like to store historical results as well. so I cant follow the trend which results create by line time. 

example. I calculate a rate in power bi every day. I would like to store in pbi the date and actual rate value. last create a chart of calculated rate from past. 

do you have any solution on this?

the only solution I have to calculate the value and store it somewhere else which is not very hand.

thx

[jaimeafanador]

Hi, Any idea of it?

thanks 

[Anonymous]

Dear Team ,

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

Regards,

Srinivas.