Create New table with values from measures

[Anonymous]

Hello!

Is it posible to create a new table with values from measures? 

The values in the matrix is what I want to get as a result

However, Im getting the sum of the value for every measure for the entire data set.

Im getting trouble how to filter or put a variable in each column to get the appropiate result.

The measures are basically deltas from a data of accounting concepts in different scenarios and companies 

Thanks!

[Anonymous]

Thanks for repliying.

What Im trying to do is to create a Water Fall chart with values from calculated measures, and since that is no possible (I beleave), I though I could transform/create a table from measures, in a way that I could arrange the columns of the matrix chart, to make a waterfall chart work. I think I'm headding to a dead end point.

[v-xuding-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly share your solutions. More people who encounter the same issue will benefit from here. If you are still confused about it, please share more details to us. 

For the difference between calculted columns and measures, please take a look at the blog:

Calculated Columns and Measures in DAX 

[v-xuding-msft]

Hi @Anonymous ,

As you tried, the results will show the total values of measures while creating tables using them. What effect do you want to show in water fall visual? You could share some sample data and expected output. Maybe we can find a workaround to implement it. 

[amitchandak]

@Anonymous , you can use summarize to create a table with the measure included. But what is the need.

Summarize and values can also be used to force row context if needed

like

new Measure = sumx(Summarize(Table, table[ID], "_1",[EBITA]),[_1])  // EBITA will calculted at ID level and then summed up