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

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

      What i really dont understand is why if i use filter=5 (the first screenshot) it works even if i remove the column from the table, but on the second case (or on the solution you provided) is not working. Since tha values are as it should be, why on some cases the table is filtered correctly and on the others not?

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

        i do not understand too.😓