Forum Discussion
How do I remove the row with zero or blank and keep anything that have value in either column
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.
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.
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
Regards,
Fahad Qadir
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
Kaviraj11
Solution Sage
Solution SageCreate 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.