Error while creating a measure

[Anonymous]

Hi,

i'm trying to create a measure like below:

Variance = CALCULATE(SUM(CashReceiveds[Applied Total])+SUM(CashReceiveds[NoMatchAmount])-SUM(CashReceiveds[Amount]))

but its not giving the desired output as some of my numbers are getting added as the first outcome is coming in -ve i.e 

SUM(CashReceiveds[Applied Total])+SUM(CashReceiveds[NoMatchAmount]).

Can someone help me regarding this?

Desired output = $24 or $-50.

Not sure why values are coming in bracket in my visual.

Regards,

Himanshu

[Icey · Accepted solution]

Hi @Anonymous ,

Try this:

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[veenashenolikar]

@Anonymous ,

Try to create a column using this DAX:

FORMAT('Table'[Column],"$#,###")

If this solves your issue, please mark this as a solution.

Regards,

Veena Shenolikar

[veenashenolikar]

Hi @Anonymous ,

I think you are using the Data Type "Currency". In this data type it shows negative values in brackets and positives without them.

Regards,

Veena Shenolikar

[Anonymous]

Yes I'm using the data type as currency only.

Is there no possibility that I can have the below output while having data type as currency.

Desired output = $24 or $-50.

When changing the data type its working fine but i want it to work on currency data type only.

Regards,

Himanshu

[Anonymous]

For reference: