Forum Discussion

gusdcruz's avatar
gusdcruz
Helper I
6 years ago
Solved

empty rows

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

Need Help
  • edhans's avatar
    edhans
    6 years ago

    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.

2 Replies

  • edhans's avatar
    edhans
    Community Champion
    6 years ago

    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.