Measures showing blank where it expects data.

[Anonymous]

I have a table measure which I'm using in a Table Visualization. The Below DAX script shows it gets data from a Measure called TotalSales. When I put the TotalSales in a Card, it displays the correct value. But when I put them in a table, it gives me a blank value. This is just a sample. My intention is to union the selectColumns with diverse data and display it in a single table. 

Thanks.

PaxMetricsTable = 


VAR TotalSales = CALCULATE([TotalSales])



	VAR DataTempTable =
	DATATABLE(
	"Category",STRING,"Actuals",INTEGER,
	{{"none",0}}
	)
	VAR TempTable =

		SELECTCOLUMNS(
			DataTempTable,
			"Category", "Total Sales",
			"Actuals",TotalSales
		)


RETURN
    TempTable

[Anonymous]

Hi @lbendlin , THanks for the quick repsonse. I tried this method before ,but can't get what I needed. Please have a look at the below screenshot. 

I need 10 rows with 2 columns which Actuals and Budget. If I add all the values in the Matrix table, it would create long list of columns rather than the format that I require. Alternatively if I create a DAX table to create the Rows and Column that I require, I would loose the data as it is relying on the Slicers SelectedValue which doesn't get passed on to the DAX Table.

[lbendlin]

You didn't do the second step.  Show values on rows.

[Anonymous]

Is there an alternative solution to make this work. I have 20 different measures that I need to display in a table visualization. Each measure has different calculations. All the measures should be based on the Slicer selections like Date, Bussiness Unit & LocationCode. 

[lbendlin]

Add the measures to a Matrix visual's values, then select "show values on rows"

[Anonymous]

Hi @lbendlin , Sorry I meant a calculated DAX Table. 

[lbendlin]

You cannot (meaningfully) create a calculated column or calculated table from a measure as the calculated item is not supposed to be impacted by the filter context.

[lbendlin]

I have a table measure

There is no such thing*. Measures can only return scalar values.

* unless your table is a single row single column table.