How do I remove the row with zero or blank and keep anything that have value in either column

[AppleJuice]

Hi, 

Im creating two columns with measures in matrix, and i want to only keep the row with values (either in one column or both columns). How do i do that? Thanks.

[Kaviraj11 · Accepted solution]

Create a Measure:

IF(SUM(Ending_Balance)+Sum(Last_Year_Ending_Balance)=0 || SUM(Ending_Balance)+Sum(Last_Year_Ending_Balance)=BLANK(),0,1))

Put the measure in Filter pane and assign it to 0.

[fahadqadir3 · Accepted solution]

Power BI File attached, I created a measure that SUM the all measures and used as filter, if its greater that zero, then it should be presented in table. 

for blank rows Uncheck the Show items with no data 

zero measure.pbix

Regards,

Fahad Qadir

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[Kaviraj11 · Accepted solution]

Create a Measure:

IF(SUM(Ending_Balance)+Sum(Last_Year_Ending_Balance)=0 || SUM(Ending_Balance)+Sum(Last_Year_Ending_Balance)=BLANK(),0,1))

Put the measure in Filter pane and assign it to 0.