topic Re: Measures showing blank where it expects data. in DAX Commands and Tips

Measures showing blank where it expects data.

Anonymous — Fri, 28 Jun 2024 13:55:23 GMT

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

Re: Measures showing blank where it expects data.

lbendlin — Mon, 01 Jul 2024 01:00:36 GMT

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.

Re: Measures showing blank where it expects data.

Anonymous — Mon, 01 Jul 2024 01:06:04 GMT

Hi lbendlin , Sorry I meant a calculated DAX Table.

Re: Measures showing blank where it expects data.

lbendlin — Mon, 01 Jul 2024 01:56:03 GMT

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.

Re: Measures showing blank where it expects data.

Anonymous — Mon, 01 Jul 2024 02:11:18 GMT

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.

Re: Measures showing blank where it expects data.

lbendlin — Mon, 01 Jul 2024 02:14:48 GMT

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

Re: Measures showing blank where it expects data.

Anonymous — Mon, 01 Jul 2024 03:09:07 GMT

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.

Re: Measures showing blank where it expects data.

lbendlin — Mon, 01 Jul 2024 13:22:44 GMT

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