Getting to the same units when working with Azure Analysis Services model using different ones

[BerlinAlexander]

I'm working with an Azure Analysis Services model, so I can't add additional columns.

I have measure A that gives me sales in thousands of EUR.

I have measure B that gives me costs in EUR.

I want to have both the measures next to each other - in thousands or in EUR, it doesn't matter. However, I don't want to have one measure in k EUR, the other in EUR.

How do I do that?

[nandukrishnavs]

@BerlinAlexander 

Try to specify the format string. 

£#,0.00

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[BerlinAlexander]

How should I do that? 🙂 I don't see a formatting option.

[nandukrishnavs]

@BerlinAlexander 

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[BerlinAlexander]

It seems impossible to change formatting for data from Azure Analysis Services:

[nandukrishnavs]

@BerlinAlexander  You have to do this in your model. 

Refer to below snapshot

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[nandukrishnavs]

@BerlinAlexander 

Another option- Define your measures in Power BI. Then Go to the model view, select the measure and apply the custom format string.

Refer to the below snapshot.

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[BerlinAlexander]

Not sure what you mean. The model view and the formatting view are inactive when you work with an Azure Analysis Services connection. If they weren't, I wouldn't have this problem.

[nandukrishnavs]

@BerlinAlexander 

Where is your measure created?

[BerlinAlexander]

I'm using Azure Analysis Services.

I connect to it by "Get Data" > Azure Analysis Services. 

I can't edit columns or format data - these options aren't available for this type of connection. 

[nandukrishnavs · Accepted solution]

@BerlinAlexander 

Try to use Tabular Editor.

https://www.sqlbi.com/tools/tabular-editor/#:~:text=The%20Tabular%20Editor%20is%20an,display%20folde....