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!

cengizhanarslan's avatar
cengizhanarslan
Super User
4 months ago

Please try the measure below as yout visual filter:

InventoryFilter =
VAR _MaxAbsValue =
    MAXX (
        VALUES ( 'Date'[Month] ),
        ABS ( [Inventory] )
    )
RETURN
    IF ( _MaxAbsValue > 0, 1, 0 )
markmsc's avatar
markmsc
Resolver I
4 months ago

Hi cengizhanarslan  --  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.