How to remove row where all measure containing 0 value.

[Anonymous]

[v-yiruan-msft]

Hi @Anonymous ,

There are 2 methods to exclude the rows which the values of Measure_1 and Measure_2:

1. Make some adjustments on the formula of Measure_1 and Measure_2, add a condition for the final return value as below: 

if ([final_value] = 0, BLANK (), [final_value])

  You can refer the solution in this thread...

2. Exclude the rows with value "0" by Filters pane

Best Regards

Rena

[Anonymous]

Thanks 

But with this approach,one measure containing 0 value will also be removed.Attaching file for your reference.

if i use this filter,Name column with Ajay will also be removed.Please note all are measure not column.Column can be used in slicer or filter but not measure.

[v-yiruan-msft]

Hi @Anonymous ，

Please try to add one condition in one of these two measures as below:

if ( [Measure_1]=0 && [final_value] = 0, BLANK (), [final_value])

Best Regards

Rena

[Anonymous]

HII

I am sorry,i am not getting desired result.Can u please take my data and share full dax formulae.

Sorry for bugging you again.

Thanks

[v-yiruan-msft]

Hi @Anonymous ,

If your problem still not be resolved, could you please provide more sample data and the formula of Measure_1 and Measure_2 refer in your previous post? It is better if you can provide your sample PBIX file. Thanks a lot.

Best Regards

Rena

[Greg_Deckler]

Yes the Filters pane?