Unable to concatenate calculated measure with HANA view column while using Direct Query mode

[itsmebvk]

HI Folks,

Can you please suggest some work around for below scenario.

How to concatenate Calculated Measure with another string column while using Direct Query mode on HANA Calc View. I created a calculated measure by concatenate multiple strings using different columns, now I want to concatenate this calculated measure with different column (string) which is available in Hana view. While I am creating new calculated measure first column is showing in expression but as soon as i use "Concatenate" second column is not showing in expression.

For example Calculated measure I created measures as follows 

URL = Concatenate("WWW.ABC.COM",[Column A])

Now I want to create a new calculated measure with following expression

New Measure = concatenate ([URL],[Column B])

When I am trying to do above expression none of the HANA Calc view column are not showing in editor, but I am able to see all the calculated measures I created in report level.

Can you please suggest any alternative method to do this?

Note : I am using Direct Query mode on HANA calc view (Dimensional ) as source , where we will have less control on query editor.

[V-lianl-msft]

Hi @itsmebvk ,

Calculated column, measure and calculated table are not displayed in the query editor.

Its scope is limited to report only i.e. after the data is populated and query editor steps are completed.

If you want to add column at query editor level, got to query editor ->Add Column -> Conditional Column.

This one would be added as a step in data tranformation.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[itsmebvk]

Hello Liang,

Thank you for your reply. As I said, I'm using the HANA Cal view as a dimensional source where I don't have access to the modeling tab and that's what my modeling looks like when I'm trying to create a calculated measure. There is no option for crated calculated column.

[edhans]

@itsmebvk you are effectively accessing tabular model, just as if you were accessing another Power BI dataset or an SSAS model. The only thing you can do is create measures. Did you try the COMBINEVALUES() function I suggested?

[itsmebvk]

Yes Edhans, I did it. I am getting Muiple value supplied where single was expected error. 😞

[edhans]

Can you share some sample data, what you are trying to do, and the expected result?

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum

[itsmebvk]

Hi Edhan,

I am sorry for not providing sample data earlier. Please see below screenshot.

[edhans]

I wasn't going to key that in @itsmebvk , but below you can see the COMBINEVALUES() measure working on other data.

If there is something strange with your data you are having issues with, please use the links I included in my post earlier to provide sample data. Screenshots are fine for expected results. Not for sample data to play with. Let me know if I can help further, or if this has provided the answer you need.

The measure is this:

Measure = 
COMBINEVALUES(
    ",",
    MAX( 'Table'[Name] ),
    MAX( 'Table'[Project] )
)

[itsmebvk]

Hi Edhan,

Thanks for your inputs. I just gone through some product documentation and understood that its PBI behavior when using Direct Query mode its not possible to play with Dimensions. I am only able to play with measures.

Appreciate your help and inputs.

Regards

Vamsi

[edhans]

My solution was a measure. I'm a bit confused.

[edhans]

Consider using COMBINEVALUES() instead of CONCATENATE(). See this article and how it relates to Direct Query.