Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
colourfullife
Post Partisan
Post Partisan

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 

How.PNG

 

table 1

아오.PNG

 

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

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

5 REPLIES 5
piyushszope
Helper I
Helper I

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?

y1.PNG

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.

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

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.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.