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...
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.😓

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

        Found the below which heps understanding the issue. Generally adding a +0 at the measure in order not to be blank, solves the filtering issue. I just need to find a solution with no adding the +0, but at least that article helps understanding the cause.

         

        Deep dive into measure filters in Power BI Desktop - SQLBI