How to remove blank rows in a calculated table?

[gvg]

Hi,

I have a calculated table made with SELECTCOLUMNS like this:

mySales = DISTINCT(SELECTCOLUMNS( Sales, 
                                  "ProductID", Sales[ProductID], 
                                  "Amount", Sales[Amount])
                  )

but it produces some blank values in Amount. How do I modify this table definition so that I get only rows that are non-blank in Amount column? I can not do this in M as this is a table derived from another table in Power BI.

[Zubair_Muhammad · Accepted solution]

@gvg

May be this one

mySales =
FILTER (
    DISTINCT (
        SELECTCOLUMNS ( Sales, "ProductID", Sales[ProductID], "Amount", Sales[Amount] )
    ),
    NOT ( ISBLANK ( [Amount] ) )
)

[AlakarHarijan1]

Hi Bro, 

Your reply was very usefull for me, I've made my table. Just a little more to add.

After making the custom table i just want to summarize one of the column, can you please help me on this.

Thank you so much.

[gvg]

Yep! Exactly. Clever solution.

Thanks!