Waterfall chart with data from a measure

[Raulx_7]

Hi, I would like to know if there is a way to create a temporary table form a measure function. 

I want to create a waterfall chart, I have 3 measures, one calculate the sales, the other the inventory and the third is calculated inventory - sales. 

My problem is that, when I create a waterfall chart I can only add one value.

That's why I decided to know if there is a way to create a temporary table (just for that chart), using those measures.

[Raulx_7]

My table is like : 

date	object	sales	original_items	ammount

As a example, 

but 3 measures that calculate using that table, with a date filter.

I want to create a waterfall (one of the measures is (item - item + item) using this as result )), with those calculated measures.

I wanted to know if there is a way to create a temp table that contains:

Item_name	Formula that calculate the value (using the above table)
1	calculate(sum(table[x]))
2	calculate(sum(table[x]))
3	calculate(sum(table[x]))

if I create this using normal dax column, the results for those formulas are not correct. That's why I would like to know if there is a possibility to create a temporal table after I calculate those values. 

[Greg_Deckler · Accepted solution]

@Raulx_7 Have you tried creating that in a measure like:

Measure =
  VAR __Table = SUMMARIZE('Table',[Item_name],"Sum",SUM([X]))
RETURN
  <some aggregation over table like SUMX, MINX, AVERAGEX, etc.>

[amitchandak]

@Raulx_7 , the only way to have a temporary table is inside a measure and that will only give you one measure.  Means in case you more than one measure you have to repeat.

You can use Summarize.

example :countx(filter(Summarize('Table','Table'[Num_Order], "_1", count('Table'[SKU])), [_1]=1),[Num_Order])

You can also have this table in Var

[AllisonKennedy]

I'm not quite sure what you mean, but you can create tables of measures using DAX and then could use that in the visual. See if this post helps: https://radacad.com/aggregated-table-in-power-bi-summarize-function-in-dax/?ref=818

If you can provide a bit more info of raw data format and desired output we can be more helpful.