empty rows

[gusdcruz]

Hi,

I have the following sales order, each line is a product
Sales order

when I try to create a visual with PGM (profit gross margin), I get this useless extra row just because PGM is 0.00. As you can see we do have products with sales tonnage and 0.00 margin, so I want to keep products with tonnage, but I want to remove the products with no tonnage

I tried to go to Query and filter by empty or blank rows, but when I go to query this is what I found.

0% is empty, so I cannt remove empty

and I cannot removed base on blank, because this option doesnt show up in the list below

Does anyone have a suggestion on how to handle this?

thank you

Gustavo

[edhans · Accepted solution]

Create a measure for Total PGM that would be like this:

Total PGM = 
VAR TotalPGM = SUM(Data[PGM])
RETURN
IF(TotalPGM = 0,BLANK(),TotalPGM)

If PGM is 0, it will return blank and not zero, and won't populate a visual.

[gusdcruz]

thank you