Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dax IF

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

 

Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    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.

5 Replies

  • piyushszope's avatar
    piyushszope
    Icon for Helper I rankHelper I
    6 years ago

    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 "".

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        v-lionel-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,

         

        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.