Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
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 "".
Hi thanks for the reply.
i've already tried remove space between "" and put 0. but still it doesn't count as number... :'(
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.
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..!
thank you!
CL
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.
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |