Creating a table of individual measures

[Anonymous]

Hi all! I have a series of measures that return a single value. I am currently displaying them on individual cards and arranging them in a table (some measures are the difference of other measures) i.e. the delta. I'd like to construct a table that can be populated element-wise with these individual measures. Could I create a new table with DAX perhaps? Thank you for any guidance.

Please see an example below where each element in the table is assumed to be a measure.

[amitchandak]

@Anonymous ,

Try a new table like

Union (
	Summarize(Table,"Name","estimated" ,"Avergae Daily profit",[estimated Avergae Daily profit],"Average Sales",[estimated Average Sales]),
	Summarize(Table,"Name","Actual" ,"Avergae Daily profit",[Actual Avergae Daily profit],"Average Sales",[Actual Average Sales]),
	Summarize(Table,"Name","Diff" ,"Avergae Daily profit",[Diff Avergae Daily profit],"Average Sales",[Diff Average Sales]),
	)

[Anonymous]

Hi @amitchandak  thank you for your answer. It definitely works! However, when I change the context of the underlying measures e.g. with a date slicer, this is not reflected in the newly created table. Is there any way around this? Additionally the measures will come from different tables but I assume this not to be an issue if the relationship model is well configured.

EDIT: Having done some research I believe it is not possible to do this? This is because "New Tables" created by DAX formulas are evaluated once on startup. Thus any filters added on (i.e. by slicers) will not have an effect on the table. Is this correct?