Forum Discussion

gvg's avatar
gvg
Post Prodigy
8 years ago
Solved

How to remove blank rows in a calculated table?

Hi,   I have a calculated table made with SELECTCOLUMNS like this:   mySales = DISTINCT(SELECTCOLUMNS( Sales,                                   "ProductID", Sales[ProductID],                   ...
Show and Tell
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    gvg

     

    May be this one

     

    mySales =
FILTER (
    DISTINCT (
        SELECTCOLUMNS ( Sales, "ProductID", Sales[ProductID], "Amount", Sales[Amount] )
    ),
    NOT ( ISBLANK ( [Amount] ) )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

gvg

 

May be this one

 

mySales =
FILTER (
    DISTINCT (
        SELECTCOLUMNS ( Sales, "ProductID", Sales[ProductID], "Amount", Sales[Amount] )
    ),
    NOT ( ISBLANK ( [Amount] ) )
)
AlakarHarijan1's avatar
AlakarHarijan1
Frequent Visitor
7 years ago

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.