How to Ask a New Question in the Community

[sunil_kumar98]

Hi,

I have a  Straight table and in that table, I have multiple dimensions and multiple measures and I want to remove those row whose test6 field value shows zero. Please see the below screenshot.

Eg.

[Kashyap_R]

Hi

Use this for Test1 Expression

=if(Aggr(Sum([test6]),[Test1])>0,[Test1])

and uncheck the show null values in dimension properties of Test1

Hope it helps

Thanks