cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
flennon
Frequent Visitor

DAX Measure with REST API dataset

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:correctSyntaxDax.JPG

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?

errorSyntaxDax.JPG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
flennon
Frequent Visitor

Re: DAX Measure with REST API dataset

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.

delme.png

 

 

 

View solution in original post

4 REPLIES 4
Microsoft
Microsoft

Re: DAX Measure with REST API dataset

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
flennon
Frequent Visitor

Re: DAX Measure with REST API dataset

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. 

 

minError.JPG

 

 

 

Microsoft
Microsoft

Re: DAX Measure with REST API dataset

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
flennon
Frequent Visitor

Re: DAX Measure with REST API dataset

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.

delme.png

 

 

 

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.