Forum Discussion

markmsc's avatar
markmsc
Resolver I
4 months ago
Solved

Filtering out zero/blank Matrix rows, part XXXVI

Hi all -- I have a variant of the old question "how do I filter out zero rows in a matrix visual" that I can't work out.  Surely it has been addressed in here somewhere, but I've not turned up the ri...
Need Help
  • grazitti_sapna's avatar
    grazitti_sapna
    4 months ago

    Hi markmsc,

     

    You can try below measure and use it as a filter on table visual

     

    Inventory Row Filter =
    VAR NonZeroMonths =
    COUNTROWS(
    FILTER(
    ALLSELECTED('Date'[Month]), -- your column field (May, June, July)
    NOT ISBLANK(CALCULATE([Inventory])) &&
    CALCULATE([Inventory]) <> 0
    )
    )
    RETURN
    IF(NonZeroMonths > 0, 1, 0)

     

    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
    💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
    🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
    🔗 Curious to explore more? [Discover here].
    Let’s keep building smarter solutions together!

danextian's avatar
danextian
Super User
4 months ago

Hi markmsc 

 

Power BI automatically removes a completely blank row so return a zero as blank.

IF ( [this measure] = 0, BLANK (), [this measure] )

 

Alternatively, you can remove zero directly from the main measure itself

CALCULATE ( SUM ( 'table'[column] ), KEEPFILTERS ( 'table'[column] <> 0 ) )
  • markmsc's avatar
    markmsc
    Resolver I
    4 months ago

    Hi danextian --  thanks for your reply.  This solution did not work for me unfortunately, possibly in part due to an issue I described in my reply to grazitti_sapna in this thread.  Please see that reply for the solution I went with.  Thank you again for your help.  Really appreciate it.