Error on Subtracting two measures having format

[Anonymous]

Hi @PaulDBrown  and @all,

Here is one more Issue i am facing. I think you can fix this. 
Continuing to the link below.
https://community.powerbi.com/t5/Desktop/sign-currency-for-only-few-rows-based-upon-condition/m-p/94...

I have subtracted two measures and applied in matrix which gives me an error as shown in the screenshot.
Change = [January] - [February]

[PaulDBrown]

@Anonymous 

Make sure that all columns and measures used in the calculations are formatted as some sort of number (not "general" nor "text" etc..)

[Anonymous]

Thanks for reply @PaulDBrown 

The calculation used for Change are measures [January Total] and [February Total] which have the same data type as shown in below screenshot.

 Change = [January Total] - [February Total] 

Still results in same error.  Is there any thing else I am missing ?

[PaulDBrown]

@Anonymous 

Try changing the "Data Type: variant" to decimal number.

If you can't do it in the measure formatting options, make sure your columns you are refrencing in the measures for the calculations are formatted as decimal numbers.

[Anonymous]

Hi @PaulDBrown ,

Unable to change the data type from Variant as few are having $ format and few don't. I have checked from lowest calculating columns and measures. I have changed them from General to Decimal Number still its the same error. 

[santiagomur]

i think some of the columns you use to calculate january total or february total is txt or some are date and other numeric. 

[Anonymous]

Hi @santiagomur ,

Thanks for reply. I have checked with calculating columns and measures. All of them are set to Decimal Number.

[PaulDBrown]

@Anonymous 

Are you using the function FORMAT in any of the columns or measures?

The error you are getting is saying that somewhere along the calculation line you have a non-number value(s)

[Anonymous]

January and February measures have both have format @PaulDBrown 

[PaulDBrown]

@Anonymous 

by "format" do you mean you are using the Function FORMAT( ) ?

[Anonymous]

yes @PaulDBrown 

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

We can try to use the following measure to meet your requirement:

Change =
VALUE (
    SUBSTITUTE (
        [January Total] & "",
        "$",
        ""
    )
)
    - VALUE (
        SUBSTITUTE (
            [February Total] & "",
            "$",
            ""
        )
    )

If it does not work, could you please share the formula of [Janury Total] and [February Total] if it does not contain any confidential information?

Best regards,

[Anonymous]

Hi,

Please try to apply the FORMAT function for the whole arithmetic operation and not for each measure.

so basicaly, FORMAT([January]-[February],....)

[santiagomur]

try use Jantotal=values(column)   FebTot=Values(column)       dif=[JanTotal]-[FebTotal]