Calculation Group Simple String Format Expression Broken When Zeros Returned Anywhere In The Result

[fraza]

Hi,

I have created a measure in Power BI Desktop that returns from a Decimal Day (i.e. 25.50) a Day, Hour, Minute etc (25 Days 12 Hours 0 Minutes).  This works without issue.

When trying to use this measure in the 'Format String Expression' in Tabular Editor 2, I am getting some strange results whenever a Zero is returned anywhere in the whole number.

I have stripped it down to only asking Tabular Editor to return the Integer of the Decimal number and the problem remains.

As can been seen here, whenever the whole number 'part' of the decimal has a Zero (0) located anywhere in it the Selected Measure result is wrong.  The right table should just be returning the integer of the left tables decimal number.

 

The measure on the left table is ... 

ROUND(AVERAGE('Case Management'[Days to Resolution]),2)

This is the exact measure in the calculation group in the right table.

The format string expression for the calculation group is...

INT([Average Days To Resolution]) & "Days"

 As can be seen below:

I have been going round in circles for sometime now. 

Anyone know why this is or how to fix it?

[fraza]

Thanks for that TheoC. 

Seemingly I cant use my DAX formated expression as the format string expression in tabular editor.

Cheers.

[TheoC · Accepted solution]

Hi @fraza 

INT is used for whole numbers (https://docs.microsoft.com/en-us/dax/int-function-dax) which is likely causing the issue.  If you cannot use ROUND to replace INT, can you use FIXED (https://docs.microsoft.com/en-us/dax/fixed-function-dax)?

Cheers.

Theo