Number Format - Total

[Anonymous]

Hi all,

I need to know how to remove total on the "Number Format"  column 

Number Format = IF(SUM('Table'[Number]) = INT (Sum('Table'[Number])),

FORMAT(SUM('Table'[Number]),"#,#"),

FORMAT(SUM('Table'[Number]),"#,0.00"))

[sivapandi]

[Anonymous]

much appreciate your reply
in my "number format " Column's options shown like this,

[sivapandi]

Hi.,

Check your data type in modeling tab for that particular coloumn. It should not be text . it should be a decimal.

Thanks

[Anonymous]

It's in Text Format because of this

Number Format = IF(SUM('Table'[Number]) = INT (Sum('Table'[Number])),

FORMAT(SUM('Table'[Number]),"#,#"),

FORMAT(SUM('Table'[Number]),"#,0.00"))
and its a requirement  to fulfill 

[sivapandi]

Hai.,

Ignore my earlier post...this will work....

Number Format =
VAR X =
    COUNTROWS ( VALUES ( 'Table'[Custom] ) )
RETURN
    IF (
        X > 1,
        "",
        IF (
            SUM ( 'Table'[Number] ) = INT ( SUM ( 'Table'[Number] ) ),
            FORMAT ( SUM ( 'Table'[Number] ), "#,#" ),
            FORMAT ( SUM ( 'Table'[Number] ), "#,0.00" )
        )
    )

[Anonymous · Accepted solution]

Finally its works with 

Column =
IF (
    Table[Number] = INT ( Table[Number] ),
    FORMAT ( Table[Number], "#,#" ),
    FORMAT ( Table[Number], "#,0.00" )
)