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

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