Is it possible to keep original number format when combing measures?

[PoweredOut]

Good morning

I have use case where I have to show two types of information in one table.

In order to achieve this I combined two measures together. The first is in currencey format and the second in whole number format. 

When I put the measure into a visual, I get the reults I need, but I would like to show the combined measure reult in the original format of both measures.

Is this possible using DAX Format for example? I have tried using it, but I get an error

Thanks

[v-jianboli-msft · Accepted solution]

Hi @PoweredOut ,

Based on your description, I have created a simple sample:

Please try:

Measure3 = 
var _a = [Measure1]
var _b = [Measure2]
return FORMAT(_a,"Currency")&" "&INT(_b)

Final output:

Best Regards,

Jianbo Li

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

[FreemanZ]

hi @PoweredOut 

try to create two measures with same code, but different format.