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

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.

  • gusdcruz's avatar
    gusdcruz
    Helper I
    6 years ago

    thank you