Forum Discussion

gap's avatar
gap
Icon for Helper I rankHelper I
3 years ago

Filter Matrix Rows to be visible only when all columns have values

Hello   My goal is to hide rows on a matrix when not all columns have value. So i created the below filter. What i am counting is the the total columns on each row (columns will be the Year), where...
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

Filter=COUNTROWS(FILTER(ALLSELECTED('Date'[Year]),ISBLANK([Basket Quantities Price]))

then, select those rows get 0

  • gap's avatar
    gap
    Icon for Helper I rankHelper I
    3 years ago

    Thanks. The problem is that it will filter the results only when the Filter measure is added to the values. Then i remove it (but of course keep it on the filters), then all the rows returned.

    • wdx223_Daniel's avatar
      wdx223_Daniel
      Icon for Community Champion rankCommunity Champion
      3 years ago

      Filter=IF(ISBLANK([Basket Quantities Price]),1)

      • gap's avatar
        gap
        Icon for Helper I rankHelper I
        3 years ago

        This will not work, since it will not return same value for all the columns on the rows i want to keep, therefore the filtering will not be correct