IF ( SUm(tablo[field1]) = Blank , 0 , SUm(tablo[field1]) ) Problem

[sinanalmac]

Hi all, I have A problem.

I couldn't find any solution on this site Please help me.

I created a table by using summarize

Table_Summary = SUMMARIZE (
Table,
Table[tYear],
Table[Month],
Table[Level 1],
Table[Owner],
Table[Categoy]
"Adjusted Loss", SUM(Table[Adjusted Loss]),
"Total Order]",SUM(Table[Total Order]),
"Inefficient Order Qty",Sum(Table[Inefficient Order Qty]))

and  I put this as a measure in the summary table

Measure =
VAR TEST1 = SUM('Table'[Adjusted Loss])/CALCULATE(SUM('Table'[Total Order]]])-Sum('Table'[Inefficient Order Qty]),ALL('Table'[Level 1],'Table'[Owner]))
RETURN IF (TEST1 = BLANK(),0,TEST1)

but it wasn't worked when I use this table in a  matrix.

It didn't show any 0 results  here is the  result  is there any  solution

thank you and best regards

Sinan   

[parry2k]

@sinanalmac try this

Measure =
VAR TEST1 = SUM('Table'[Adjusted Loss])/CALCULATE(SUM('Table'[Total Order]]])-Sum('Table'[Inefficient Order Qty]),ALL('Table'[Level 1],'Table'[Owner]))
+0
RETURN TEST1 

I would 💖 Kudos 🙂 if my solution helped. If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[sinanalmac]

thank you @parry2k

But I tried your solution but only it changed the results.

I'm trying to do this.  

I just marked red to indicate. doesn't have to be red

 best regards
Sinan 

[parry2k]

@sinanalmac so what you are getting when added +0 ?? What do you see? Can you share the screen shot?

[sinanalmac]

hey @parry2k 

here it is 

[parry2k]

@sinanalmac I see what is going on, your calculation is not actually returning blank() but it probably has values after the decimal, if you increase the decimal to 10 points and you will probably see some values, can you check it?

[sinanalmac]

hi, @parry2k  thank you for your interest.

I have been working on this file for 3 hours.But I couldn't get any solution.  I put the file in a dropbox folder. I wonder what I can't see

if you have time to look  you can  find the files in the link below

https://www.dropbox.com/sh/w4fuymtxiktwlpi/AACRx-JwF2QlVAocqj066qVZa?dl=0 

Thank you 

[parry2k · Accepted solution]

@sinanalmac I recreated your file and matrix, everything in blue background color is new, you don't need to create a summary table to get you going. The updated pbix is attached.

I would 💖 Kudos 🙂 if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[sinanalmac]

Thank @parry2k   you are a lifesaver.

Although I tried so hard, I could not find a solution.  If you concentrate on one place, you cannot see the solutions in other places.(this is for me🙂) 

If you have a request from Istanbul, please let me know. I would love to do it happily.
Best  Regards
Sinan