Need to show the rounded value in datatype of decimal based on a condition.

[ChandanaP]

From the image here in the matrix I have customer names in the hierarchy contains the customer key. so my question is I have to show only Alexandria Rogers sales amount as 159 and remaining customers sales amount in decimal values as 159.00 so for that I have wrote one calculated column it is working fine in data view but when I consume that in Report It is not showing as expected. And I am new to powerbi. Need help on this. 

                         Thanks in advance.

[Samarth_18 · Accepted solution]

Hi @ChandanaP ,

Please update your code as below:-

roundedVal =
IF (
    'internetsales'[customerke] = 12162,
    FORMAT ( 'internetsales'[salesamount], "#0" ),
    FORMAT ( 'internetsales)'[salesamount], "#0.00" )
)

BR,

Samarth

[ChandanaP]

Thank you for your reply.Like the same way I have solved.