Create a list of measures and their values in a column

[Stanzarectah]

Hi,

I would like to convert some measure values:

into a table like this:

Name	Actual
Total Income	($6,075,988)
Total Expense	$18,450
Total COGS	$4,452,726

Any ideas?

[johncolley · Accepted solution]

Hi @Stanzarectah, 

You can accomplish this with a disconnected (no relationships to other tables) table that holds the values of the measures you want to display.

Then use a switch statement to display the correct value.

display = 
var selection = SELECTEDVALUE(Disconnected[Measure Name])
RETURN
SWITCH(
TRUE(),
Selection = "Total COGS", 'Time'[Total COGS],
Selection = "Total Expense", 'Time'[Total Expense],
Selection = "Total Income", 'Time'[Total Income])

Then create a table with the Measure column from the disconnected table and the display measure.

[Stanzarectah]

Thank you so much @johncolley for the quick response !

I was able to achieve this and it works like a charm.