topic DAX Measure with REST API dataset in Developer

DAX Measure with REST API dataset

flennon — Thu, 21 Jun 2018 16:25:55 GMT

I've created a Push streaming dataset, and I'm trying to combine two of the columns (Strings) into a new measure. I've looked up the syntax which displays the following:

When I try it shows an error. This syntax works correctly when I'm connecting to a database, but shows an error with the streaming dataset. I'd say that it just wasnt possible to create a measure for a streaming dataset, but it gives you the option to create one, when it doesnt give you the option to create a custom column. Can anyone advise on what I can do?

Re: DAX Measure with REST API dataset

v-jiascu-msft — Fri, 22 Jun 2018 09:06:46 GMT

Hi @flennon,

That's a common error in a measure. That's because a value of these column can't be determined. Please try it like below.

=concatenate(min('products'[Product abbreviation]), min('products'[Product number]))

Best Regards,

Dale

Re: DAX Measure with REST API dataset

flennon — Tue, 26 Jun 2018 09:58:49 GMT

Thanks for the reply Dale.

I had copied the syntax from the MSDN Docs here

I attempted to add in the min() to the formula but the values I'm trying to concatenate are strings. It did not give a syntax error but the formula does not display any values as shown below. Any further advice would be greatly appreciated.

Re: DAX Measure with REST API dataset

v-jiascu-msft — Mon, 02 Jul 2018 01:49:25 GMT

Hi @flennon,

How about adding the measure in the table, the right one in your snapshot? Or you can change the left visual into a Card visual. Your old formula can work in a calculated column that isn't supported in your scenario.

Best Regards,

Dale

Re: DAX Measure with REST API dataset

flennon — Mon, 02 Jul 2018 14:14:34 GMT

Measures I found needed an aggregate applied to them.

I wanted to combine the two strings so that both values would appear on the X-axis of a chart as I thought before it would only display one value or the other. This was resolved by selecting the view 'At Lowest Level of Data' as seen below. Thanks for the help.