Filter

[Calvin]

Hi Community, 

I am trying to filter out some values by using DAX.

Column A   Column B

A                   (blank)

B                        0

C                        1

D                        2

How do I filter out (blank) and 0 in column B. 

Thanks. 

Thanks 

[amitchandak · Accepted solution]

@Calvin . If you need a new measure

C = calculate(Sum(Table[Column B]), Filter(Table, Table[Column B] <>0  && not(Isblank(Table[Column B]) ) ) )