Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

exclude blank rows in new table

I created an new table where i summarized the sale by product group. Some product groups have no value.. what dax formula should I use in order to exclude them thank you
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi

 

  Use the below Script and consider this measure as final one instead of the existing one.

 

NewMeasure = CALCULATE(
    SUM( Table1[Value] )
    ,NOT( ISBLANK( Table1[Id] ) )
)

Replace the Table1 with your table or query name and id with your product Group column (which has no value or empty)

 

Thanks

Hari