Dax IF

[colourfullife]

Hi, 

I need a help!

Made a calculation table1 below.

in last column i took only + numbers from beside with this dax1 below.

i want to make a graph based on the last column but it doesn't count as number although it's number type already..

any idea?

dax 1 

table 1

[piyushszope]

I think that is because you are specifying the space in the formula at the end " ". Try to specify the value at the end or remove the space between the quotations "".

[colourfullife]

Hi thanks for the reply.

i've already tried remove space between "" and put 0. but still it doesn't count as number... :'(

[v-lionel-msft]

Hi @colourfullife ,

What is the data type of your [Current Surplus (Recived-Rom)] column?

Can you convert the data type manually?

If you still can't solve it, please give a sample data and I will help you test it.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[colourfullife]

hi @v-lionel-msft 

thanks for your reply. i tried and it didn't work as i wanted.

i shared my file in the link. please check and be so appreciated with any help..!

native file 

thank you!

CL

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

current surplus = SUMX(VALUES('Matrix_Ident Library'[Ident Code]),IF([Current Surplus (Received-BOM)]>0,[Current Surplus (Received-BOM)],""))

Hope this helps.